1 Reply Latest reply on Oct 20, 2018 5:02 PM by patrick.byrne.0

    Dinamically show/hide measures

    Jaime Baltazar

      Scenario,

      I have a date field and a dimension on the columns

      I have another dimension and the measures names on the rows

      On the marks I have the measure values and on the measure values I have 6 measures.

       

      the table is like below example

      ColumnsState NameSaturday date
      RowsProduct NameMeasure Names

       

      The result of this is a Table like below.

      California
      <Measure names>Sep 8, 2018Sep 1, 2018Aug 25, 2018Aug 18, 2018Aug 11, 2018Aug 4, 2018
      Product 1Sales1616516168896514831826158891538981683152
      Cost Sales264884618648456415312354
      Logistic Cost123545214866848478644851
      Other costs1315414849
      Profit15699918948748956489456489456485444
      Profit after taxes14894615486439456448641418654426548
      MouseSales16165116889614831826158891538981683152
      Cost Sales264884618648456415312354
      Logistic Cost
      Other costs
      Profit156991894848956489456489456485444
      Profit after taxes148941548639456448641418654426548

       

      As you can see, some products have no Logistic Cost and Other costs, we have 24 products. For those products that do not have any logistic cost and other costs, I want to dynamically hide these measures and show just the measures with values like below. We can show/hide, dynamically choose measures, exclude, etc.

       

      Expected result

      California
      <Measure names>Sep 8, 2018Sep 1, 2018Aug 25, 2018Aug 18, 2018Aug 11, 2018Aug 4, 2018
      Product 1Sales1616516168896514831826158891538981683152
      Cost Sales264884618648456415312354
      Logistic Cost123545214866848478644851
      Other costs1315414849
      Profit15699918948748956489456489456485444
      Profit after taxes14894615486439456448641418654426548
      MouseSales16165116889614831826158891538981683152
      Cost Sales264884618648456415312354
      Profit156991894848956489456489456485444
      Profit after taxes148941548639456448641418654426548

       

      Thanks in advance.