Hi all,
I am looking for a way to make an extra calculated field in a pivot table. This is for a monthly report I need to make. (every month I need to pay someone for the activities he did. Therefore, I created a table and from that table a pivot table (and I want to make a chart from that later)
Now my question. I would like to put a third column in the pivot, in that column the amount I need to pay.
I can make it with a formula next to the pivot like =IF(A3="Cleaning";B3*150;IF(A3="Driving";B3*100;B3*50)) but than it is not in the pivot, and that is what i need.
Can somebody help me out?
I am looking for a way to make an extra calculated field in a pivot table. This is for a monthly report I need to make. (every month I need to pay someone for the activities he did. Therefore, I created a table and from that table a pivot table (and I want to make a chart from that later)
Now my question. I would like to put a third column in the pivot, in that column the amount I need to pay.
I can make it with a formula next to the pivot like =IF(A3="Cleaning";B3*150;IF(A3="Driving";B3*100;B3*50)) but than it is not in the pivot, and that is what i need.
Can somebody help me out?
Example.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | Activity | Counts | Costs per service | |||||||||
3 | Cleaning | 6 | Cleaning | € 150.00 | ||||||||
4 | Driving | 20 | Driving | € 100.00 | ||||||||
5 | Walking | 3 | Walking | € 50.00 | ||||||||
6 | Running | 12 | Running | € 50.00 | ||||||||
7 | Singing | 9 | Singing | € 50.00 | ||||||||
8 | ||||||||||||
9 | ||||||||||||
10 | TO PAY | |||||||||||
11 | Row Labels | Sum of Counts | ||||||||||
12 | Cleaning | 6 | ||||||||||
13 | Driving | 20 | ||||||||||
14 | Running | 12 | ||||||||||
15 | Singing | 9 | ||||||||||
16 | Walking | 3 | ||||||||||
17 | Grand Total | 50 | ||||||||||
18 | ||||||||||||
Sheet1 |