Set expressions for current Quarter and Month sales.

[deepakahirwar]

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 

[jaibau1993 · Accepted solution]

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.