Thanks, but it gives the sum from today till last 3 months from today. However, my requirement is that in Aug, it gives sum for last 3 months including August.
So for current data, Last 3 months sum for P1 in Aug will be 93+54+74+84 i.e sum of june data +sum of july data +sum of august data
Hi Aabhas, I think a Table calculation might help. This will compute a rolling 3 month sum.
This calculation can do different things in the view depending on how you set it after it is in the view. Be sure that it is set to look at columns across the table - which in this setup is months (rather than looking up/down the table - SubCategory). Click the arrow on the Measure pill, choose Compute Using > and choose Table Across. For this option, be sure your months are sorted in order so that the previous two columns are the correct ones to Sum with the current column.
The Rolling 3 Months calculation needs the months in its calculation to actually be in the view. So for instance, if you're find rolling three months for June 2018, April and May have to be in the view - you can't filter them out or they won't be counted in June's sum. What you can do so that you're only seeing the month or months you care about is create a calculation like Norbert's, put it in the view, and then hide the columns that you don't want to see.
Here you can see an example calculation - this will find the last 3 months not counting the current month, but you can make this calculation anything you like.
Put it on the Columns shelf after Month(Date). If you put it before Month(Date), the Month(Date) sort order will be off. You can see this returns True or False depending on whether it's the Months you want to show. Right-click on any False value, and choose Hide.
Now you only have the three months you want. You can get rid of the "True" column header. Right-click on any True value, and un-check "Show Header"
Rolling 3 months.twbx 362.5 KB