partial sum of pivot table disreagrding the current sellections

[#1]

Hello everyone,

I am having trouble with mt pivot table. I am trying to get the figure of that day (not sum of all days) disregarding the current sellections.

Here is a formula I ma currently using. This formula disregards all selections but returns the total of all days.

sum({1<APKO_LIABILITIES_ACIKLAMA = {'Kat�lma Hesaplar�'}>} TOTAL (APKO_MT_TL_BAKIYE))/1000

In case I could not express my problem well, here is the screen shot.

I would be grateful if anyone can help.

[brenner_martina · Accepted solution]

HI,

you can enter after TOTAL for wich dimension(s) you want to get the partial sum, something like:

Sum({} TOTAL <Dimensionfield1, Dimensionfield1> APKO_MT_TL_BAKIYE)

[#3]

Thanks Martina.

The final formula is below

Sum({1} TOTAL <dimensinfield1, dimensinfield2> APKO_MT_TL_BAKIYE))