Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table for the balance sheet with 5 dimensions and expression to display debit - credit amount
for some accounts I'm multiplying the sum(debit-credit) by -1; based on client's request
so suppose under dimensionality 2 I got two partial sums
now for dimensionality 1 the partial sum should be the difference in partial sums of dimensionality 2
is this possible?
Hi there,
I am pretty sure it is possible. But I am not sure how you want to display it.
Do you want have in one expression? Or do you want multiple coloms?
Can you maybe upload an example or screenshot of how you want the result to be shown?
Dennis.