Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does anyone have an example data to base a Pivot Table on?
I am trying to practice creating a Pivotal Table but do not have any multiple
sheet data. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does anyone have an example data to base a Pivot Table on?
Zed1 wrote:
I am trying to practice creating a Pivotal Table but do not have any multiple sheet data. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
What happens if the data base changes; will the Pivot Table autom | Excel Discussion (Misc queries) | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
pivot table with dynamic base data | Charts and Charting in Excel |