Rolling grayed out

[qlikviewaf]

Anyone knows why the Rolling is grayed out?

How i can solve this?

[Anil_Babu_Samineni]

"Accumulation" section won't visible for Pivot Table..

[qlikviewaf]

Which could be a solution ?

[Anil_Babu_Samineni]

To overcome in Pivot table? you need to write expression?

RangeSum(Above(TOTAL Your Measure, 1, RowNo()))

[qlikviewaf]

I would like to have the sum of last 12 month based on the maximum "Invoice_date" done on the selection.

How this can be build?

This is the formula for sales based on the selection (imagine May - 2017)

=Sum(ExtendedUSD)

Which shuold be the formula to retrieve the last 12 month sales ?

Thanks for clarifing!