Total of rows of first expression

[francisvandergr]

I included an example.

I like to have a total in my second expression. i like to have an total of expression 1 for all values from above for each row

[ahaahaaha · Accepted solution]

Hi,

Try

RangeSum(Above(Sum(Qty), 0, RowNo()))

Look attached file

Regards,

Andrey

[francisvandergr]

Ok thnx! and what when i have a extra dimension ? !

[francisvandergr]

Ok thnx! and what when i have a extra dimension ? !

I included an second example with an extra dimension

[Frank_Hartmann]

in this case just change the order of your dimensions.

for pivottable use this dimension order:

Prod,Article,Date

for straighttable use this dimension order:

Date, Article, Prod

hope this helps

[ahaahaaha]

Look attached file