ignore the dimension in the pivot table

[#1]

Dear Experts,

I have one issue, please kindly help me out resolve the issue.

I have a pivot table similar to the excel attached. Sorry could not attach the app for you. Also I have two list boxes.

For the Estimated Stock row, I have the requirement to get the sum of stock from day 1 of the records to the particular month. I have explained in the excel. Hope it will help you understand.

How do i write the expression.? I have written the expression using

sum({<Year=, Month=, date={">=$(=min({<Month=,Year=>} date)) <=$(=max(date))"}>} movemntqty)

But the month dimension is restricting the records to only that month while summing up.

Thank you.

[swuehl · Accepted solution]

Set analysis won't regard your current dimension value (Month dimension), it's evaluated once per chart, not per row.

So you would need some other approach to get the quantities cumulated like you intend to. I think the easiest would be to calculate your cumulative stock in the load script, if that's feasible.

[#3]

Thank you for the response.

Can you help me by providing a little more explanation on 'once per chart, not per row'.?