merging 3 expression into one expression

[Anonymous]

Hello all,

I am three expression say:

RollingMonth as a dimension

PreviousMonth_CurrentYear =sum({<RollingMonth={'$(=VPM)'}>} SalesAmount)

CurrentMonth_CurrentYear =sum({<RollingMonth={'$(=VCM)'}>} SalesAmount)

CurrentMonth_PreviousYear =sum({<RollingMonth={'$(=VCM)'}>} SalesAmount)

where as variable are

VPM= =MonthName(AddMonths(max(SalesDate),-1))

VCM= =MonthName(max(SalesDate))

VCMLY= MonthName(AddMonths(max(SalesDate),-12))

Can I merge these 3 expression into 1 expression by using Pick,Match,WildMatch function etc.

Regards,

Balraj

[Anonymous]

Why its not working on Year or month???

[sunny_talwar]

You mean why it is not working on a selection in Year or Month Fields? What would you want to see when you make a selection there? We might have to play around with the variables to make it work with selection in those fields.

[Anonymous]

hi

try:

=sum({<RollingMonth={'>=$(=VCMLY)'}>} SalesAmount)

if not please can you elaborate on what you want to achieve.

Regards

Neetha

[sasiparupudi1]

Sunny,

What if the dimension is made as a calculated dimension

only({<RollingMonth={'$(=VPM)', '$(=VCM)', '$(=VCMLY)'}>} RollingMonth)

and expression as

=Sum(SalesAmount)

Sasi

[kavita25]

What is your format of Rolling Month field??

[sunny_talwar]

Not sure how it would work, but definitely worth giving a short.

[Anonymous]

This would not work as it would be giving you all the values of which is greater then my VCMLY..

[Anonymous]

I have simply used monthname(date) as rollingmonth

[Anonymous]

Not working..

[sunny_talwar]

You did not respond to my question here:

You mean why it is not working on a selection in Year or Month Fields? What would you want to see when you make a selection there? We might have to play around with the variables to make it work with selection in those fields.