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.
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.