Partial vertical sum in pivot table

[alex59800]

Hello all,

I try to set a partial sum in a pivot table.

Tow dimensions, markets and delay.

My wish is to make a sum of amount considered out of delay (0-30 days until +360 days), from the rest of the dimension (in time).

The actual pivot at the top of the excel attached and what i am looking to achieve just below.

Thanks a lot for your help

PS: i tried

=if(columnNo()=4 ,RangeSum(before(Sum(montanttest),0,  ColumnNo(TOTAL)))) bit i have still column with null value inside i can not get ride of....may be something to do with set analysis do not know

[sunny_talwar]

Is delay a calculated dimension or a field which is getting calculated in the script?

[marcus_sommer]

I think you need to create your "Total not in time" as an additionally field-value for the field delay (maybe you create an extra dimension for this) and then your expression would be like:

if(delay = 'Total not in time', sum(total <Markets> montanttest), sum(montanttest))

- Marcus

[alex59800]

Hello Sunny it's an inline function in the srcipt depending (today - due date).