Hi,
I have sales data where they can be categorized in multiple categories. For example, on 10/1 I have 5 sales (notated by the last row) and they can fall under 6 categories. Here is sample data:
Date . Name . Value
10/1 . Purses . 2
10/1 . Shirts . 3
10/1 . Watches . 1
10/1 . Shorts . 3
10/1 . Hats . 5
10/1 Socks . 3
10/1 Total Sales 5
So, there are 17 categorizations (2+3+1+1+5+3+5). I want to create a pivot table that shows the grand totals (excluding the total sales) and also create a % variable that is value divided by total sales. So, it would give me a column total of 17 instead of 22 and also 2/5 for purses, 3/5 for shirts, etc. The sample data above is only for one day, the data would have multiple dates. I am trying to use a pivot table because new categories might arise, etc.
I have sales data where they can be categorized in multiple categories. For example, on 10/1 I have 5 sales (notated by the last row) and they can fall under 6 categories. Here is sample data:
Date . Name . Value
10/1 . Purses . 2
10/1 . Shirts . 3
10/1 . Watches . 1
10/1 . Shorts . 3
10/1 . Hats . 5
10/1 Socks . 3
10/1 Total Sales 5
So, there are 17 categorizations (2+3+1+1+5+3+5). I want to create a pivot table that shows the grand totals (excluding the total sales) and also create a % variable that is value divided by total sales. So, it would give me a column total of 17 instead of 22 and also 2/5 for purses, 3/5 for shirts, etc. The sample data above is only for one day, the data would have multiple dates. I am trying to use a pivot table because new categories might arise, etc.