I am trying to practice creating a Pivotal Table but do not have any multiple sheet data.
Z Zed1 Dec 13, 2008 #1 I am trying to practice creating a Pivotal Table but do not have any multiple sheet data.
S smartin Dec 14, 2008 #2 Zed1 said: I am trying to practice creating a Pivotal Table but do not have any multiple sheet data. Click to expand... Pivot tables do not require multiple sheet data, just an array of categories and values. Try pivoting this data to determine total sales by company and product: Company Product Sales A X 100 B X 106 A Y 500 B Y 450 A Z 350 B Z 175
Zed1 said: I am trying to practice creating a Pivotal Table but do not have any multiple sheet data. Click to expand... Pivot tables do not require multiple sheet data, just an array of categories and values. Try pivoting this data to determine total sales by company and product: Company Product Sales A X 100 B X 106 A Y 500 B Y 450 A Z 350 B Z 175
