Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why its not working on Year or month???
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.
hi
try:
=sum({<RollingMonth={'>=$(=VCMLY)'}>} SalesAmount)
if not please can you elaborate on what you want to achieve.
Regards
Neetha
Sunny,
What if the dimension is made as a calculated dimension
only({<RollingMonth={'$(=VPM)', '$(=VCM)', '$(=VCMLY)'}>} RollingMonth)
and expression as
=Sum(SalesAmount)
Sasi
What is your format of Rolling Month field??
Not sure how it would work, but definitely worth giving a short.
This would not work as it would be giving you all the values of which is greater then my VCMLY..
I have simply used monthname(date) as rollingmonth
Not working..
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.