cumulative summation in pivot table

[ali_hijazi]

Dears

got a pivot table with 2 dimensions Brand and Week

the expression is to display the avg discount by brand and week

my expression is (A-B)/A where A is the original retail and B is the effective retail

so far so good

but how can I make an expression that displays for week 2 the result for week 1 and 2 then for week 3 the result of week 1, 2, and 3 and so on

Please advise

[#2]

So you want to cumulatively concatenate strings so that in your third column you add the avg discount for that new week?

Could you share some sample data and an example of the desired outcome?