Totals in pivot table

[#1]

Hi All,

I've been trying to solve a problem for a week now, and now I need some help.

I have a pivot table looking like this:

In this pivot table I would like to have partial sums, that are not calculating some complex formulas, but only sum() all the values for the previous level. To be more clear I've marked those values in red in the image.

I tried using dimensionality(), but I just can't get it work right. The expression I'm using for this column is really complex. Another thing I tried is reworking the expression to be something like: SUM(if(...)), now it looks like if(sum(...)), but got no results.

Now what I'm wondering is is there a way to just sum() those cells may be using Inter records or functions like above().

Any help will be greatly appreciated!

Best,

Maya

[hector]

Hi, the result of an expression if(sum().... sum(if)....is different, check if you can improve th exp.

rgds