9 Replies Latest reply on Dec 18, 2017 11:01 AM by shwetha sarma

    Breaking dimension into multiple dimension

    shwetha sarma

      Hello,

       

      I have a dimension called Parameter_type. It is based on 3 attributes called Fixed, Efficient and Variable. I want to be able to have 3 separate filters on the dashboard. One for each (Fixed, Efficient and Variable). In the filter option,  want choose the department names.

       

      So, each filter will have same department options . But user will be able have multiple filter option to view anything as fixed, variable or efficient. I'm having a hard time breaking this up.

       

      I also created another dimension called "Parameter_Name" that has both Parameter_type and department. Please let me know the easier way to do this.

       

      Attached is the a sample workbook.

       

      Thanks,

      Shwetha D.