2 Replies Latest reply on Mar 9, 2017 7:50 AM by Viji Ramesh

    Count the number of records for the 2 different sets of dimensions in a sheet

    Viji Ramesh

      Hi all,

      I'm struggling to figure out the solution of this problem for the last 2 days. I would really appreciate your help.

      My table looks like this

       

      ZoneStateTypeCountDateZone1State1Type1Count1    Date1
      Z1S1T111-JanZ1S1T111-Jan
      Z2S2T212-JanZ1S1T111-Jan
      Z2S2T212-JanZ1S1T111-Jan
      Z1S1T111-Jan
      Z1S1T111-Jan
      Z1S1T111-Jan
      Z2S2T212-Jan
      Z2S2T212-Jan
      Z2S2T212-Jan

       

      I need the result like this

       

       

      Zone        State       Type          Date        X
      Z1S1T11-Jan1/6
      Z2S2T22-Jan

      2/3

       

       

      Here, X is the calculated field which is the ratio of the number of records of the dimensions (Zone, State, type, date)/

      number of records of the dimensions (Zone1, State1, type1, date1).

       

      Thanks!