Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to make my table YTD sales = Jan + Feb Amount ?
Hi All
I have below expression from Mr Manish :-
SUM({<year = {"$(=Max(year)-1)"},rEVENUE={"rEVENUE"}>}Amount*1)/1000
it work fine , but now i like to modify it , so that it can give me YTD sales .
Meaning if i click on month = 2 , i like it display jan + feb amount.
Can some one help me ?
I will post my QV sample in few minute.
PAUL
Hi,
Use this expression
SUM({<year = {"$(=Max(year)-1)"}, month={'<=$(=Max(month))'}, rEVENUE={"rEVENUE"}>}Amount*1)/1000
Regards,
jagan.
May be try this..
SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},rEVENUE={"rEVENUE"}>}Amount*1)/1000
Hi,
Use this expression
SUM({<year = {"$(=Max(year)-1)"}, month={'<=$(=Max(month))'}, rEVENUE={"rEVENUE"}>}Amount*1)/1000
Regards,
jagan.
Hi,
Check this link for similar type of expressions if you have a date field
Set Analysis for certain Point in Time
Set Analysis for Rolling Periods
Hope this helps you.
Regards,
Jagan.
Hi All
Both reply work , thank you very much.
Paul