Is it possible to "ignore" dimension for one expression ?

[#1]

Hi,

my case is much more complex but basically : i have month of year as a dimension  and a few expressions in a pivot table. Is it posible to "ignore" dimension in one of expressions ? For example expression is sum(Price) but i want sum of prices for prior six months, in january i want that result for this expression is sum of last six months in back year (this six months are not and visible in this chart) ? 

Thanks in advance

[swuehl · Accepted solution]

Try this as expression in your pivot table:

aggr(rangesum(above(sum(Price),1,6)),YearMonth)

[#3]

Swuhel,

it works. Thanks a lot.

By

[#4]

Dear Swuhel,

I have a similar kind of issue. Can you please help.

I want to get the sum of stock from day 1 to particular month(pivot table dimension is month) and selected Year in a list box for specific brand?

How do I write a expression for it?

[MarcoWedel]

Please open a new thread.

thanks

regards

Marco