Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community!
Is it possible to get only one column and sum all columns in front of in a pivot-Table? Thanks in advance!
Br
Mike
can you please brief about it?
Hy!
I have a pivot-Table with 5 dimensions and 1 summarized field. i need one more field that calculates an Percentages about two fields.
Br
Mike
May be this?
Num(Sum(TOTAL <Field1, Field2> Measure),'#,#0%')
Or
Num(Sum(Aggr(Sum(Measure), Field1, Field2)),'#,#0%')