showing six month sales

[manu1512]

Hi all,

Greetings

is there any way to show last six month sales with out using mtd and rolling month sales

Regards

Manu

[adityaakshaya]

Hi Manu,

You can create a variable to calculate the last sixth month and make first date as datevalue and use that variable in set analysis. something like below

vLastSixthMonthDate = Month(Today())-6

Sum({<Date = {">=$(vLastSixthMonthDate)"}>}Sales)

Hope this helps you.

Regards,

Akshaya

[duncanblaine]

Hi Manu
Akshaya's solution is a good one.
Another way you can do it, if you are trying to build a chart and don't want to include variables, is to use Dimension Limits.
To do this you'll need a chart Dimension which is your distinct Months ie 'MonthYear' (format 'DD-YYYY')

On Dimension Limits tab you need to

• Select your MonthYear dimension
• Check Restrict which values are displayed using the first expression
• Show only First 6
• Uncheck Show Others
  

On Sort tab, you need to

• Sort by MonthYear, Numeric descending
• Remove all sorting on your expression eg Sum(Sales)

Hope this helps.