4 Replies Latest reply: Jun 9, 2017 4:58 AM by Sunny Talwar RSS

    Help on set variable

    Prasanna zad


      I am trying to make a pivot table which comprise of budget headcount data (month on month) . By design, the headcount numbers are progressive (e.g  Feb'17 heacount numbers, will show Jan+Feb (YTD)). i need help on how to ensure that for any given month, the table shows me data relevant only to that period.


      my set variable


      sum({<Scenario={Budget}, HeadCountType={"HC Request","PH","Open","PHWS","Attrition Replacement"},DateType={THD},year={$},month={$}>}[FTE_Alloc])


      Thanks in advance