Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dynamic whatif parameter

Hi,

I have the following table

 

part of below schema (id<->id)

 

now i have the following report:

 

i need to add a filter to this report where i can select a week. however this week cannot be greater than the dim[current week] for this id.

i was thinking of using a whatif parameter but i'm not able to limit it to the dim[current week] 

how would you achieve this?

thanks

 

 

 

 

 

 

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous if you add week slicer from this model, once you slicer the "id", it will also filter week value. Make sure when you use week slicer, the slicer type is dropdown or list.

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous if you add week slicer from this model, once you slicer the "id", it will also filter week value. Make sure when you use week slicer, the slicer type is dropdown or list.