Subtotal in Pivot Visual

Question & Answer
, ,
1

Hi,
I have a requirement to change the Subtotal aggregation in Pivot visual. So the Scenario is I have a measure column with multiple rows grouped by a couple of dimension fields. The Measures values needs to be aggregated as sum so that I will be getting all the values summed for a particular category, in the same time I need the subtotal as average of that Category. Is that possible in Quicksight or is there any workaround for it?

Example
Backend Data:
Category | Orders |
Dress 10
Dress 20
Dress 10

Expected Output:
Category | Orders |
Dress 40
Subtotal 13.33

Current Output:
Category | Orders |
Dress 40
Subtotal 40

Thanks

2

Why don’t you add the same measure again in the table with an Avg aggregation, something like this.

image
image827×563 49 KB

Regards,
Giri

3

Hi,
I need it with a single column only and that was the part of the requirement. Thank you for your suggestion.

4

Hi @Yamini_Baskar_24,
It’s been awhile since last communication on this thread so wanted to follow up and see if you’re still encountering the same issues or if you’ve been able to find a work around in the time since.

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!