ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Does anyone have an example data to base a Pivot Table on? (https://www.excelbanter.com/excel-worksheet-functions/213589-does-anyone-have-example-data-base-pivot-table.html)

Zed1

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.

smartin

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


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com