Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one pivot table where I am using following formula:
sum(Aggr(Count(DISTINCT {<[Abrechnungsplanhilfe.VORRAT]-={'Endabgerechnet', 'Erledigt'}>} [Abrechnungsplanhilfe.VORRAT]), [Abrechnungsplanhilfe.OIDVARTKOMBI]))
The total result is OK, but wrong splitted. For example,offen i wrong at the beginning, but after the filtering the offen I get the right value.
First screenshot is wrong and the second one is correct.
What is the reason for that?