4 Replies Latest reply: Feb 29, 2016 9:02 AM by bruno bertels RSS

    Dynamic field in simple table

    Cyrille Thybert

      Hi All,

       

      I would like to create a table with one dynamic field :

       

      I have measures :

       

      unit quantity

      sales

      margin

       

      And dimensions :

       

      product

      country

      customer

       

      The tableau should appear like this :

       

      productunit qtsalesmargin
      Shoes12$12324$123
      Book21$23456$321
      Chairs32$3454$234

       

      and I would like to click on something to switch the dimension to another :

       

      countryunit qtsalesmargin
      USA12$12324$123
      UK21$23456$321
      China32$3454$234

       

      The "thing" to click could be a filter or or a selector.

       

      Also be able to dynamically add a dimension like this :

       

      countrycustomerM1M2M3
      USAJack3$123$12
      USAMike4$345$23
      UKPaul5$23456$321
      UKBill3$234$43
      ChinaPatrick2$3454$234
      ChinaSimon1$234$54

       

      I could use a Pivot table but I want my users to dynamically add and remove whatever the dimensions they want.

       

      Anyone has an idea ?

      Thank you,

      C.