0 Replies Latest reply on Feb 27, 2013 6:31 AM by Raina S

    Computing ratio for a field with the grand total

    Raina S

      Hi,

       

      Can anyone help me with my query,

       

      I have 8  'segments', under each segment I have many 'stores' and under each store there are many 'assets'.

      There is a dimesion work_order_ type from which I need to filter only types "PM" and "CM" and view work order count for these types.

       

      Global Filter: Store, Month and Segment

       

      My question is,

       

      I need to calculate ratio of total work order count of PM/total work order count of CM for the store located. this is done.

       

      I also have to calculate one more ratio which will have total work order count of PM/total work order count of CM for the segment the store is located in. Total value for all the stores in that particlar segment the store selected is located in.

       

      something like given below,

       

      Asset    CM   PM    Store %   Segment %

      A            1       1     100          45

      B             2       4      50           23

      C             3       6      50          78

      D             4       2     200         34

      E              5       8                   12

      F              6       8                     45

       

      Store % will have the total work order `count of PM/total work order count of PM for that particular store selected

      Segment % will have total work order `count of PM/total work order count of PM for that segment the store is located in.

       

      Pls someone help