HI Sajdmalik....what you want ....I mean you want to get the last 6 months sales or what you exactly want
If you want to get salesw of last six month ...than you can go for set analysis.
and use sum(if(inmonth(Field1, $(vPeriod), -6), Sales))
and MY will be
date(monthstart($(vMinDate) + rowno() - 1), 'MMM-YYYY')
I have a trending graph that displays the field 'Reporting Period' as Jan-2011, Feb-2011......July-2011 and so on on the X-axis and corresponding cost for a particular metric on the Y-axis.
So what I want is when nothing is selected the trending should be displayed for all the months present in the dataset. But if user selects a particular month for Ex: July-2011 the graph should display months from Feb-2011 up until July-2011 i.e basically the last six months.