hairyfingers
New Member
- Joined
- Sep 10, 2015
- Messages
- 18
Hi
If I have this table:
I can produce this pivot table
But what I want to do is produce a pivot table that looks like this:
So I need some sort of calculated field that calculates from a single column of the source data
Is this possible??
my actual data set as 392000 rows and 43 columns and I'm using Excel 2013
If I have this table:
Name | Type | amount |
foo | Red | 2 |
bar | Red | 4 |
fiz | Blue | 3 |
buz | Blue | 5 |
foo | Orange | 1 |
bar | Orange | 3 |
fiz | Green | 5 |
buz | Green | 3 |
I can produce this pivot table
Sum of amount | Column Labels | ||||
Row Labels | Blue | Green | Orange | Red | Grand Total |
bar | 3 | 4 | 7 | ||
buz | 5 | 3 | 8 | ||
fiz | 3 | 5 | 8 | ||
foo | 1 | 2 | 3 | ||
Grand Total | 8 | 8 | 4 | 6 | 26 |
But what I want to do is produce a pivot table that looks like this:
sum of blue & green | sum of orange & red | Total | |
bar | 0 | 7 | 7 |
buz | 8 | 0 | 8 |
fiz | 8 | 0 | 8 |
foo | 0 | 3 | 3 |
Grand Total | 16 | 10 | 26 |
So I need some sort of calculated field that calculates from a single column of the source data
Is this possible??
my actual data set as 392000 rows and 43 columns and I'm using Excel 2013