Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Please refer the Attached snapshot for the issue.
Selected Value
Quarter 1 - with the Month
selection as March.
Expecting:
Current Month Sales,
Prev Month Sales &
Next Month Sales.
Only on Quarter basis.
Issue is that --> As Q1 is selected ...But 3rd column values
goes into the another quarter which must be Jan-2014 or within the quarter sales .
Thanks & Regards,
Deepak
Hi!
You have to NOT take into account selections made in "Quarter" field. You clear field selections by writting the field name in the set expression. Said so, use
Sum({<CALENDAR_QUARTER, [Month Year]={'$(vNextMonthYear)'},Year=,Month=,Date=>}Act_Amt)
for "next month" expression.
Regards,
Jaime.
Hi!
You have to NOT take into account selections made in "Quarter" field. You clear field selections by writting the field name in the set expression. Said so, use
Sum({<CALENDAR_QUARTER, [Month Year]={'$(vNextMonthYear)'},Year=,Month=,Date=>}Act_Amt)
for "next month" expression.
Regards,
Jaime.