Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SWITCH function to present one value in whole row

I have SWITCH function like below....

 

I have function to return EBITA value in case group category is Admin 

It works well 

 

Currently the value is assigned to my matrix only in column with name category = Admin . 
I would like to assign the same value for other columns with different names. 

I would be happy for your resply with info what is the logic behind. 

THX!

Switch()

4 Replies

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    Anonymous, Can you share the expected output screenshot?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Below you can find expected outcome

      value from admin column should be presented in other columns too (the places with red dot)

       

      • SivaMani's avatar
        SivaMani
        Icon for Resident Rockstar rankResident Rockstar
        5 years ago

        Anonymous, Try this,

         

        Instead of ADMIN_step2_cost centers[Group ] = "ADMIN"   

        Filter( ALL(ADMIN_step2_cost centers[Group ]),ADMIN_step2_cost centers[Group ] = "ADMIN")