# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## Rolling N Months Calculation

Hello,

I have a table like this:

JanFebMarAprMay
Amount120232302322382

When I select Apr, the Pivot Table only shows:

Apr
Total = Sum(Amount)322

How could I make Total to be sum of Feb's, Mar's and Apr's amount, i.e. rolling 3 months, and giving out 856, i.e. 232 + 302 + 322?

3 Replies
Honored Contributor II

## Re: Rolling N Months Calculation

See the attached file

Not applicable

## Re: Rolling N Months Calculation

Hello,

Thanks for your help. However, is there a way I could hide the previous months? For example, if I select Apr and May, Feb and Mar would be hidden, however, Apr and May could still show the accumulated total. Is that possible? Please help and advise. Thank you.

## Re: Rolling N Months Calculation

See this document for some solutions: Calculating rolling n-period totals, averages or other aggregations

talk is cheap, supply exceeds demand