3 Replies Latest reply on Dec 31, 2015 5:18 AM by azhor mohammadd

    DYNAMIC COLUMN SELECTION

    azhor mohammadd

      Hi all,

       

      I have a scenario like below:

       

      I have 10 fields in Data Source in that 8 are dimensions and 2 are measures.

       

      Dimensions are like

        1.Business Name

        2.Business Type

        3.category ..etc fields

      Measure like

        1.Count

        2.Amount

       

      I want a dynamic column, row and detail column representation in my sheet/dashboard. In this we should have three Quick Filter shelf items like

        1. ColumnShelfFilter(All dimension Names),

        2. RowShelfFilter(All dimensions Names),

        3. DetailShelfFilter(All Measures).

       

       

        If I select value in ColumnShelfFilter That dimension has to display in column shelf of sheet/dashboard and that value has hide/disable in RowShelfFilter

        If I select a value in RowShelfFilter that dimension has to display in rows shelf of Sheet/dashboard and that value has hide/disable in ColumnShelfFilter

        If I select a value in RowShelfFilter that dimension has to display in detail/ABC area of Sheet/dashboard.

       

        My total intention is to create a sheet or dashboard with dynamic column/row/detail value selection with fixed visuals.

       

      Thanks,

      Azhor.