Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the attached sample I am trying to be able to select a year and month and see in the chart the 5 periods prior to the month selected and 5 periods after the month.
Example Year: 2010 Month: December
Desired Results in Chart:
Jun-10 Jul-10 Aug-10 Sep-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11
Hi
Hope my example attached qv file will be helpful for your requirement
Regards
Ashok
Hi,
Check with this expression
Sum({<DateField={">=$(=MonthStart(Max(Date),-5))<=$(=MonthEnd(Max(Date),5))"},YearField=,MonthField=>} FieldName)
Hope it helps
Celambarasan
I applied the formula but get no data back. Can you input the formula in the attached QVW to see if you get success?
Hi,
I'm using personal edition i cann't open your file.
Celambarasan
Thanks for trying. I could not get to work. I must be using wrong fields.
Celambarasan,
In my chart I current have the following. How would I modify your suggestion with these?
Dimension: Month
Expression: Sum ([Spend (USD)]/[Qty Received (NO DIM)])
Hi
Hope my example attached qv file will be helpful for your requirement
Regards
Ashok