Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be using a pivot table where periodid is a pivoted dimension?
Something like this to add %Change
Dear Sunny ,
Thanks a ton for your updates. I will check and update you.
Thanks & Regards,
Milind.
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
Dear Sunny ,
Thanks a ton. Its really helpful for me . I resume today after vacation.
Thanks
Milind.
Yes. Its helpful and resolve my issue.