How to make my table YTD sales = Jan + Feb Amount ?

[paulyeo11]

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

[settu_periasamy]

May be try this..

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},rEVENUE={"rEVENUE"}>}Amount*1)/1000

[jagan · Accepted solution]

Hi,

Use this expression

SUM({<year = {"$(=Max(year)-1)"}, month={'<=$(=Max(month))'}, rEVENUE={"rEVENUE"}>}Amount*1)/1000

Regards,

jagan.

[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.

[paulyeo11]

Hi All

Both reply work , thank you very much.

Paul