customized partial sum! is this possible

[ali_hijazi]

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?

[Anonymous]

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.