topic Create Last Column in PivotTable in QlikView

Create Last Column in PivotTable

mmitteregger — Wed, 17 Apr 2019 08:36:17 GMT

Hello Community!

Is it possible to get only one column and sum all columns in front of in a pivot-Table? Thanks in advance!

Mike

saminea_ANZ — Wed, 17 Apr 2019 09:04:16 GMT

can you please brief about it?

mmitteregger — Wed, 17 Apr 2019 09:10:11 GMT

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.

Mike

saminea_ANZ — Wed, 17 Apr 2019 09:19:12 GMT

May be this?

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

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