Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when i am practising set analysis i found some difficulty in writing the expression.please can anyone help me in getting solution for my doubts
Top 10 Records
Bottom 10 Records
Current Year Vs Previous Year
Current Month Vs Previous Month
Last 5 Years Records
Last 6 Months Records
Last 4 Quarters Records
Current Quarter Vs Last Year Same Quarter
Current Month Vs Last Year Same Month
Hi ,
Check these links ,
Set Analysis for certain Point in Time
Set Analysis for Rolling Periods
Better Go one by one, and search for better understanding.
HTH,
hirish
Hi Shiva,
If you get answer please close this thread.
Thanks
Try like this
Current Year and Current Month Exp:
sum({$<Year={$(=Max(Year))},Month={ "<=$(max({<Year={$(=Max(Year))}>} Month))>$(Max({<Year={$(=Max(Year))}>}Month)-1)"}>}
Last Year and Current Month Exp:
sum({$<Year={$(=Max(Year-1))},Month={"<=$(Max({<Year={$(=Max(Year))}>}Month))>$(Max({<Year={$(Max(Year))}>}Month)-1)"}>}
---------------------------
For Current Year :
Sum({<year= {$(=max(Year))}>}Sales)
For Previous Year :
Sum({<Year= {$(= max(Year-1))}>}Sales)
i got the answer..but i dont know how to close the thread.
Mark it correct ...
Not there you will get this option at below on left hand side you no need to reply that just check left hand corner side.