alphabo1201
New Member
- Joined
- May 2, 2019
- Messages
- 16
Hello,
Is there any way to create a calculated field when there is multiple columns in pivot table?
there is two fields inserted in to column section and use the number from there to create calculated field.
I am trying to create Rev Prod- cost 1 field.
For example: Data would look like this
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Once pivoted:
<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Is there any way to create a calculated field when there is multiple columns in pivot table?
there is two fields inserted in to column section and use the number from there to create calculated field.
I am trying to create Rev Prod- cost 1 field.
For example: Data would look like this
Name | overall | Detail | Net |
a | Revenue | Rev ser | 10 |
b | Revenue | Rev Prod | 10 |
a | cost | cost 1 | 5 |
b | cost | cost 3 | 3 |
e | G&A | G&A | 5 |
f | G&A | G&A | 5 |
g | ETC | ETC | 1 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Once pivoted:
Sum of Net | Column Labels | |||||
Revenue | cost | ETC | G&A | |||
Row Labels | Rev Prod | Rev ser | cost 1 | cost 3 | ETC | G&A |
a | 10 | 5 | ||||
b | 10 | 3 | ||||
e | 5 | |||||
f | 5 | |||||
g | 1 | |||||
Grand Total | 10 | 10 | 5 | 3 | 1 | 10 |
<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>