Forum Discussion
Pivot Table with Average Values and Sum Totals
Hi there, I have an issue displaying information in my pivot table where I have parent companies and their subsidiaries. The revenue reported is at the Parent Company level so has been ente...
That is a bad table.
In the attached file the solutions A and B.
Solution A uses a helper column with an amended revenue.
Solution B splits the data in two tables.
