Alice Morland
New Member
- Joined
- Apr 26, 2018
- Messages
- 37
Hello forum!
I have a question for you knowlegeable people; how can I change what's in a pivot's values without actually going to the PivotTable Fields area. Ideally, I'll be using a slicer.
This is the raw data:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The first pivot is this:
<colgroup><col><col></colgroup><tbody>
</tbody>
I'd like to replace the Values column by the Count of Document Numbers:
<colgroup><col><col></colgroup><tbody>
</tbody>
In conclusion, is there any way to do that without going into the PivotTable Fields area? I'm asking because the report users would rather not get technical.
Big thanks!!
I have a question for you knowlegeable people; how can I change what's in a pivot's values without actually going to the PivotTable Fields area. Ideally, I'll be using a slicer.
This is the raw data:
Name | Document No. | Values |
John | 11 | $35 |
Mary | 154 | $558 |
Adrian | 21 | $120 |
John | 14 | $100 |
John | 344 | $48 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The first pivot is this:
Row Labels | Sum Values |
Adrian | 120 |
John | 183 |
Mary | 558 |
Grand Total | 861 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I'd like to replace the Values column by the Count of Document Numbers:
Row Labels | Count of Doc Number |
Adrian | 1 |
John | 3 |
Mary | 1 |
Grand Total | 5 |
<colgroup><col><col></colgroup><tbody>
</tbody>
In conclusion, is there any way to do that without going into the PivotTable Fields area? I'm asking because the report users would rather not get technical.
Big thanks!!