Forum Discussion
Marcelo Magri
Oct 06, 2023Copper Contributor
Comparing data in pivot table grouped by month
Hello everyone, I apologize in advance if this is something obvious (that I'm missing). I have a pivot table that groups monthly the number os lab exams that need to be redone due to certain cir...
- Oct 06, 2023Yes just copy your current Pivot table. Then right-click in the data area of the pivot and choose "Show Values As...", "Difference From". Then set the appropriate options.
JKPieterse
Oct 06, 2023Silver Contributor
Yes just copy your current Pivot table. Then right-click in the data area of the pivot and choose "Show Values As...", "Difference From". Then set the appropriate options.
- Marcelo MagriOct 08, 2023Copper ContributorThank you very much! Sorry for the late reply.