7 Replies Latest reply on Jan 21, 2019 11:03 PM by Yvonne Cheng

    Do Arrgegation on grouping dimension

    Yvonne Cheng

      Hi All,

       

      I would like do calculate ratio based on vessel name grouping. (pls refer to attached sample data)

       

      Firstly I would like to group vessel name. Kota Carum and Kota Cempaka are group A. The rest is group B.

      Then calculate ratio (COUNTD(observation) / COUNTD (report number)) based on group A, group B and all (vessels).

      I want a view like this:

      Ratio (Group A)Ratio (Group B)Ratio (All)
      1.50.50.83

       

      I tried this formula, but it did not work out.

      Appreciate you could help me.

       

      Best Regards

      Yvonne