Dynamic variance analysis / How to hide the column in pivot table

[milindnikumbh]

Dear Experts ,

How to hide the non - selected the month in pivot table . My excel data and qvw file is attached for your reference.  I have generated the MonthID column in fiscal year . Can we create dynamic year-month instead of hard codded month-yr in expression and also calculate variance.

Please suggest the approach to achieve this .

Thanks.

Regards,

Milind.

[sunny_talwar]

May be using a pivot table where periodid is a pivoted dimension?

[sunny_talwar · Accepted solution]

Something like this to add %Change

[milindnikumbh]

Dear Sunny ,

Thanks a ton for your updates. I will check and update you.

Thanks & Regards,

Milind.

[Brett_Bleess]

Milind, just wanted to be sure you circled back on this one to mark Sunny's posts as the solution using the Accept as Solution button on those posts if they did work out for you.  

Regards,
Brett

[milindnikumbh]

Dear Sunny ,

Thanks a ton. Its really helpful for me .  I resume today after vacation. 

Thanks

Milind.

[milindnikumbh]

Yes. Its helpful and resolve my issue.