set analysis

[#1]

I have a requirement that need to get current year values for previous year sales executives only

how to get it by set analysis?

[anandathome]

Could you give an example.

What fields are there to identify previous year sales executives?

Please post a sample application.

[MK_QSL]

Could you please explain your requirements? if possible, please some sample data or file for better understanding.

[jagan]

Hi,

Try like this using P() in set analysis

=Sum({<Year={$(=Year(Today()))}, SalesExecutive=P({1<Year={$(=(Year(Today()) - 1))}>})>}  Sales)

Regards,

Jagan.