1 Reply Latest reply on May 1, 2018 11:01 PM by SAMAR KRISH

    Crosstab report - each column to be aggregated based on different logic

    SAMAR KRISH

      Hi all,

       

      I am looking for an aggregated cross tab report based on the data source below. Each column use different logic for aggregation. Please see the attached excel for the formulas involved.

       

           

      Data source - sample
      S.NoDimensionMeasure1Measure2Measure3
      1AY0.5TRUE
      2BN2.5FALSE
      3CD3.5FALSE
      4AY1.5TRUE
      5BY1.4TRUE
      6CY1.3TRUE
      7AN1.32FALSE
      8BD2FALSE
      9CY3.5FALSE
      10AY4TRUE
      11BN1.23TRUE
      12CD2.43TRUE

       

       

      Expert Tableau worksheet

      Category % total - Msr1% total - Msr2% total - Msr3
      Y50.00%58.33%58.33%
      N25.00%41.67%41.67%
      D25.00%0.00%0.00%