Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic column value based on slicer selection

Hi,   Have searched the previous posts on Dynamic selected, but cannot find solution to my scenario. Below are the tables I have.   Table: Material Type   Mat Type Key Mat Type T...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous great explanation but it is not clear by selecting mat key why different Hier will show up, like in this case, what is the logic to show stock by Hier L2?

 

When B is selected, I need to show Stock by Hier L2
Type Stock
H23 300

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks parry2k. That is my business requirement. The report should show different column values based on what is selected. Are you able to help how do I achieve this?

 

When B is selected, I need to show Stock by Hier L2
Type Stock
H23 300 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous ok, so you will never see stock for mat type B by any other Hier. Are these fixed business rule or it is dynamic?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the reply parry2k . 

      Correct these are fixed rules.