VizLib Pivot Table: Group Sum

[ChristofZ]

hello,

I have a VizLib Pivot Table with a few Dimensions and Values - the Table is grouped by the A and/or B column, the table inserts Totals after each group.

I need to calculate the value of the totals by formula - so far I've tried things like aggr(sum(C), A, B) and sum(aggr(...)) and various combinations, sum({1} C), sum(all C), sum(total C),  etc etc.

RangeSum() doesn't help me either, because you can't ask it to sum the current group.

Any help would be greatly appreciated.

A	B	C
A1	B1	3
A1	B1	5
A1	B1	2
		Total 10
A2	B2	4
A2	B2	1
A2	B2	3
A2	B2	4
		Total12

[ChristofZ]

ok - found it:

sum(Total <A, B> [C])

you really have to narrow it down giving all the dimensions of the group ("<A, B, ...>") you want to sum up column C in.

Thank you! 😎