2 Answers
- Newest
- Most votes
- Most comments
1
You could create a calculated field and use the sumOver function .
the measure would be the aggregated value you are looking for (max in your case), partition by the dimension in the pivot and you can leave blank the third parameter (the default is POST_AGG_FILTER that is what you are looking for).
Using QuickSight samples Sales Pipeline analysis the calculated field (max_revenue) would be:
sumOver(max({Weighted Revenue}),[Region])
the result would look like the pivot table on the right in this screenshot.
Relevant content
- asked 9 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a month ago