Hello
I would like to change pivot values or filters using a dynamic value of a separate cell.
So for example I can put in a cell '1' or '2' and the pivot will filter accordingly or calculate some fields accordingly.
Is that possible? I only know that it needs to click refresh or it can be set to update every specific time interval.
Btw, I would need NO VBA!
Thanks!
I would like to change pivot values or filters using a dynamic value of a separate cell.
So for example I can put in a cell '1' or '2' and the pivot will filter accordingly or calculate some fields accordingly.
Is that possible? I only know that it needs to click refresh or it can be set to update every specific time interval.
Btw, I would need NO VBA!
Thanks!