3 Replies Latest reply on Nov 20, 2018 6:18 PM by Hari Ankem

    Keep one dimension value as default and other dynamic

    soni s

      Hi Guys,

       

      I want to show the avg profit for each category per state. The furniture category should always be present as default category in the view and as the user selects other categories it should add additional columns in the view.

      so, if user wants to see office supplies then it will be state | Furniture | Office supplies columns displayed on the view.

      If the user wants to see office supplies and Technology then it will be State | Furniture | office supplies | technology on the view.

       

      PFA sample workbook.

       

      Thanks,

      Soni