Multiple value aggregation Pivot Table Option

Support
#1

Hi,

I want to aggregate on multiple values on same row column feature.
I tried the pivot table option in chart as well as report, but I am not able to aggregate on more than 1 column
I have attached an excel representing the data and expected output.
Kindly Assist.
Thanks :slight_smile:

Regards,
Aruna
pivot example.xlsx (10.8 KB)

#3

Hi,

The provided example looks like a custom table rather than a Pivot Table. Unfortunately, PivotTable included to the Charts component can’t generate such data output.

Regards,
Gleb

#5

Hi Gleb,

Thanks for the quick response.
I am not sure if I was able to express my concern with the example clearly.
The output is not a custom table, i prepared using pivot option of excel.
Attaching the screen shot of the options selected in excel to get the output.

Let me know if this will be possible via charts.

image

Regards,
Aruna