Total sum of row in Pivot

TomR — Fri, 19 Nov 2021 13:02:30 GMT

Hello,

I would like to have a pivot table that shows a ratio over the second (column) dimension (Zahlungsmethode) for each of the items in the first (row) dimension ...

The numbers shown above are the counts for each of the "Zahlungsmethoden".

In the formula for now I have : count (distinct Auftragsnummer)

Now, I need the sum of each in the row to calculate the ratio of each Zahlungsmethode :

1 row would be 208 (-> Ratio for : Zahlung bei Abholung = 176/208 etc ....)

2 row would be 298 (-> Ratio for : Zahlung bei Abholung = 239/298 etc ....)

Thanks a lot ...

Thomas

Re: Total sum of row in Pivot

rubenmarin — Sat, 20 Nov 2021 09:31:14 GMT

Hi, that could be: count (distinct Auftragsnummer)/count (distinct TOTAL <RowFieldName> Auftragsnummer)

Change RowFieldName with the name of the field you are using as row dimension.

If the same Auftragsnummer may be on different Zahlungsmethoden you'll need something different like use an Aggr:

count (distinct Auftragsnummer)/Sum(Aggr(count (distinct TOTAL <RowFieldName> Auftragsnummer),Zahlungsmethoden))

topic Re: Total sum of row in Pivot in App Development

Total sum of row in Pivot

Re: Total sum of row in Pivot