Hi,
Is this possible to show values as difference from previous month and previous year in one pivot table?
From the beginning...
I have simple table with numerical values for few days across two months, and I'd like to show values as difference from previous year and previous month as is grouped in pivot table - you can see it in attached file.
The issue is that if I show values as difference from previous month - I can see it for months only.
Similarly for previous dates. Morover I cannot see difference for first date from second month unless I remove months level from pivot table.
Is there any way to achieve this result?
Is this possible to show values as difference from previous month and previous year in one pivot table?
From the beginning...
I have simple table with numerical values for few days across two months, and I'd like to show values as difference from previous year and previous month as is grouped in pivot table - you can see it in attached file.
The issue is that if I show values as difference from previous month - I can see it for months only.
Similarly for previous dates. Morover I cannot see difference for first date from second month unless I remove months level from pivot table.
Is there any way to achieve this result?
