Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am creating a table that have Month to Date value in it, using set analysis.
if i use "Department" as dimension in the table, the MTD value will shown correctly.
But if i change to "Date" dimension the value seems to breakdown for each day not accumulated.
I have attached an image showing what result that i am expecting and the result that currently QV shown.
I use 3 selection list box in the report, "Year" (e.g 2012,2013), "Month" (Jan, Feb), and Day (e.g 1,2,3,4) and must be at least one value selected properties are checked.
and my set analysis for MTD is : sum({$<Day={"<= $(=max(Day))"}>} [Sales Amount Gross]).
Thanks in advance.
Hi
PFA... Hope it will help you
Regards
Nirmal
Hi Piyajate,
Try this expression for your MTD
=sum({<Date = {">=$(=Date(Max(Monthstart(Date))))
<=$(=Max(Date))"}>} [Sales Amount Gross])
Hope it will work for you.
- Regards,
Vishal Waghole
Hi,
i am still not getting the expected result.
What i was expecting is let say the value are like below :
for the MTD i am expecting that for 2 Jan it will be accumulated between 1 and 2 Jan value (5+10) which is 15, like below :
if the dimension were change to other than "Date" then my MTD expression will work correctly, but not if using Date dimension
hi
PFA.... refer the two straight tables hope it will helps you
Hi Nirmal,
it worked!
Thanks alot!
Hi Nirmal,
it worked!
Thanks alot!