2 Antworten
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor einem Jahr