LTD(Live Till Date) calculation

[#1]

Hi All,

I have the req as per attachment.

I have to calculate the count of numbers and values based on the selections in design level through set analysis is an added advantage.

If am selecting the particular month it has to show the number and value count in that month and number and value count upto that month as well.

Total i have to show 4 fileds in staright table.

MTD NO     MTD Value     LTD NO          LTD Value.

Here am attaching the sample data and and o/p format also.

Thanks in adv,

Ravi

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#3]

Thanks Gysbert,

Its working.If its very great full if we apply the logic in design level itself.

Because currently am unable to touch the data model.

As per mine we have to create the same script in design level also like variable.But am stuck to pass the variable in set analysis.

Help the same.

Thanks,

Ravi