My data is not that large, about 1000 rows but I want to look at it in different ways.
One pivot tables shows the average auction price for each hour.
One pivot tables shows the average auction price for each month.
I have several more but you get the idea. The problem is that when I group one by month the other one changes and when I change the other back it affects the other. I want to have several tables on the same sheet. I tried to click the box, "Defer Layout Update" but that did not help.
Can someone help me?
One pivot tables shows the average auction price for each hour.
One pivot tables shows the average auction price for each month.
I have several more but you get the idea. The problem is that when I group one by month the other one changes and when I change the other back it affects the other. I want to have several tables on the same sheet. I tried to click the box, "Defer Layout Update" but that did not help.
Can someone help me?