Does anyone have an example data to base a Pivot Table on?

Z

Zed1

I am trying to practice creating a Pivotal Table but do not have any multiple
sheet data.
 
S

smartin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Data Aggregation 0
Pivot table grouping help 0
Excel does not accept text format! 0
Pivot Table cell values 1
Multiple Tables and Multiple Pivot Tables Help 0
Creating a Chart on form from selected data in query. 0

Top