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
