maxwell888
New Member
- Joined
- Jun 2, 2016
- Messages
- 6
I have a dataset which contains two fields and data similar to below.
I can create a powerpivot table as per below
<tbody>
</tbody>
How can I create an extra category? - type c which is calculated from the other two - i.e. c = 2*a + 2*b
Note that in PowerPivot table tools -> analyse -> Fields, Items and sets, - Calculated field and calculated item are greyed out.
<tbody>
</tbody>
Dataset
<tbody>
</tbody>
I can create a powerpivot table as per below
a | 75 |
b | 151 |
<tbody>
</tbody>
How can I create an extra category? - type c which is calculated from the other two - i.e. c = 2*a + 2*b
Note that in PowerPivot table tools -> analyse -> Fields, Items and sets, - Calculated field and calculated item are greyed out.
a | 75 |
b | 151 |
c | 452 |
<tbody>
</tbody>
Dataset
Type | Count |
a | 43 |
a | 32 |
b | 76 |
b | 54 |
b | 21 |
<tbody>
</tbody>