Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
In pivot table how to show the previous month data without any filter selections.
I have a date and month fields.
Thanks
Deepak
See if this links help:
The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync
UPDATE: Adding a snippet from the above link
Do you have date or month as dimensions in your pivot table?
In dimensions field i don't have a month and date fields.
See if this links help:
The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync
UPDATE: Adding a snippet from the above link
Is there another way to achieve this requirement?. Because i am not familiar with set analysis, otherwise can u explain
briefly how to achieve this?
Thanks
With the amount of information you have provided, I am not sure if there is another simpler way to do this, but you can look into here: The As-Of Table.
Also, if you are able to provide a sample, may be one of us can show you how this can be done in your sample file.
Best,
Sunny
I recommend learning about set analysis, then. It's a very useful tool, and probably simpler than implementing an AsOf table, even if AsOf tables are my go to solution for many date-related problems. I'm not thinking of a third way, but also won't be surprised if someone posts one.
Hi ,
Use set analysis , its simple and very useful .
Thanks for your suggestion. it's working ,simply superb..
I am glad you put in effort to finally able to resolve your issue. This will def. go long way for you to learn set analysis if you are not used to using it much.
Best,
Sunny