View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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