
Contributor III
2021-11-17
12:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Percentage based on dimension
Hi,
I have a pivot table with dimensions Category and Item. I want to create a percentage column defined as the item amount divided by the item category amount.
Any suggestion on how to create the percentage column please. Thank you.
1,701 Views
1 Solution
Accepted Solutions

MVP
2021-11-17
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, you can use the TOTAL qualifier to tell the expression to ignore dimensions, and between <> tell wich dimension it has to use, so this can be:
Sum(Amount)/Sum(TOTAL <CategoryFieldName> Amount)
1,623 Views
1 Reply

MVP
2021-11-17
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, you can use the TOTAL qualifier to tell the expression to ignore dimensions, and between <> tell wich dimension it has to use, so this can be:
Sum(Amount)/Sum(TOTAL <CategoryFieldName> Amount)
1,624 Views
