Summation w.r.t rows.

[deep2021]

Hi,

Please find the attached excel,

I need a summation of total w.r.t rows in the pivot table. I have to show the output in the Table.

Could you please suggest on this.

Thanks

[QFabian]

Hi @deep2021 , please check if this works for you, i used a CROSSTABLE function, then you can use the new fields 'Number' and 'Percentage' in your charts

WRT:
CROSSTABLE(Number, Percentage, 1)
LOAD
Col2,
"1",
"2",
"3",
"4",
"5",
"6",
"7",
"8",
"9",
"10",
"11",
"13",
"14"
FROM [lib://YOUR_LIB (YOUR USER)/test1.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

[deep2021]

Hi,

I need summation of rows as per the pivot in the straight table and that is too in percentage.

Above technique won't work.

Thanks

[QFabian]

Something like this?, it is a pivot table

[deep2021]

yeah, the total w.r.t a single row

[deep2021]

Total should not be w.r.t column. It should be w.r.t row.

Mean total for Row A and Total for Row G and it is separate

Thanks