Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Greetings
is there any way to show last six month sales with out using mtd and rolling month sales
Regards
Manu
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
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
On Sort tab, you need to
Hope this helps.