Create Last Column in PivotTable

[mmitteregger]

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

[saminea_ANZ]

can you please brief about it?

[mmitteregger]

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

[saminea_ANZ]

May be this?

Num(Sum(TOTAL <Field1, Field2> Measure),'#,#0%')

Or

Num(Sum(Aggr(Sum(Measure), Field1, Field2)),'#,#0%')