Is there a way to show Running % of total in pivot table analysis like in Excel?
Can someone help.
This feature is supported on QuickSight Pivot table. Please refer the below documentation to use the Running Total function.
Pivot table function does not have ‘Running percent of total’. Result showed in example is after applying ‘percent of total’ function from QuickSight.
I need same function like ‘running total’ but in percentage which is not listed.
Count1% Count1%+Count 2% And so on
Is there any other way it can be done, percent value is based on count aggregate.
Hi, we don’t provide running percentage as a direct on-visual table calculation, but you can create calculated fied for that purpose, something like
runningsum()/sumover() depending on the dimension and value how you want to conduct the calculation.