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

Help on set variable

Prasanna zad Jun 8, 2017 10:56 AM

Hi,

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

Re: Help on set variable

Sunny Talwar Jun 8, 2017 1:10 PM (in response to Prasanna zad)

Are you using Year and Month as your dimensions?
Like Show 0 Likes (0)

Actions
- Re: Help on set variable
  
  Prasanna zad Jun 9, 2017 4:08 AM (in response to Sunny Talwar )
  
  Yes i am
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Help on set variable
    
    Sunny Talwar Jun 9, 2017 4:58 AM (in response to Prasanna zad)
    
    In that case you have two options
    
    1) Use The As-Of Table
    2) Use Missing Manual - Above() and Below() functions
    
    Like Show 0 Likes (0)
    
    Actions
Re: Help on set variable

Antonio Mancini Jun 9, 2017 4:14 AM (in response to Prasanna zad)

You remove
Month={$),Year{$} don't need
Correct is
Year=$::Year,Month=$::Month
however You don't need because you don't have any Alternate State in Your Expression.
Default is Current state/selection {$}
Like Show 0 Likes (0)

Actions

Go to original post