K
Kevin Labore
Hello
I am wondering if there is a easy way to compare 2 pivot tables.
There have been many times where there is not a way to show a comparison of
2 sets of data in one pivot table.
What I have done in the past for scenario is to have a workbook that has 2
worksheets containing the 2 pivot tables.
I then have a 3rd worksheet that compares the data in the 2 pivot tables
using GETPIVOTDATA.
This work fine in most cases however setting up the 3rd sheet can take some
time.
One example of where I might want to compare 2 pivot tables: I have a Pivot
Table that shows the Score Test results of an assessment test By School,
Grade, Subject, Year. I want to show a view of how a particular school did
in comparison to ALL schools. While you can easily compare 2 Schools in a
pivot table there is not a way to create a view to compare ONE school to ALL
schools with the data I am comparing. As I mentioned having a separate
worksheet reference and compare the 2 pivot tables manually was the way to
accomplish this. Normally the Pivot tables have the same structure and the
page Field would be SchoolA on one pivot table and "ALL" for the 2nd pivot
table.
I have tried searching for info on this but haven't come across of any
explanation/examples of comparing 2 pivot tables(With a 3rd PivotTable)
Thanks in advance for any help
Kevin
I am wondering if there is a easy way to compare 2 pivot tables.
There have been many times where there is not a way to show a comparison of
2 sets of data in one pivot table.
What I have done in the past for scenario is to have a workbook that has 2
worksheets containing the 2 pivot tables.
I then have a 3rd worksheet that compares the data in the 2 pivot tables
using GETPIVOTDATA.
This work fine in most cases however setting up the 3rd sheet can take some
time.
One example of where I might want to compare 2 pivot tables: I have a Pivot
Table that shows the Score Test results of an assessment test By School,
Grade, Subject, Year. I want to show a view of how a particular school did
in comparison to ALL schools. While you can easily compare 2 Schools in a
pivot table there is not a way to create a view to compare ONE school to ALL
schools with the data I am comparing. As I mentioned having a separate
worksheet reference and compare the 2 pivot tables manually was the way to
accomplish this. Normally the Pivot tables have the same structure and the
page Field would be SchoolA on one pivot table and "ALL" for the 2nd pivot
table.
I have tried searching for info on this but haven't come across of any
explanation/examples of comparing 2 pivot tables(With a 3rd PivotTable)
Thanks in advance for any help
Kevin