Total sum of row in Pivot

[TomR]

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

[rubenmarin]

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))