PDA

View Full Version : Sleeper: Selecting the previous month of pivot table automatically



sri16
01-09-2014, 01:04 PM
Hi!
I have a pivot table - I need to select the previous month automatically to refresh data from cube. From the month drop down we should
be able to select the previous month .Appreciate any help for using variable
Thanks
s

Bob Phillips
01-17-2014, 06:58 AM
What do you mean by select the previous month automatically?

fb7894
08-17-2018, 05:34 AM
My guess is to automatically select a PT slicer or filter, you would need to use VBA