1 2 Previous Next 19 Replies Latest reply on Jul 2, 2018 9:19 PM by Mahfooj Khan

    Row Level Ratio from the same dimension

    Lolakshi Gour

      Hello All,

       

      I am running into an issue and I have really hard time solving the issue. Let me explain my scenario.  I have a table as below. Under a region, there are multiple locations(for example 012). And each location has multiple node_parent_name example REVENUE, Merchandise, Payrol with their totals for 2018.

       

                               

      region idlocation name/ numberNODE_PARENT_NAMEFY 2018
      212 alexandria, vaREVENUE650000
      MERCHDSE17100000
      PROD_PAYROLL9950000

       

       

      Under each node_parent_name, I have gl codes with their respective amounts.

       

      region idlocation name/ numberNODE_PARENT_NAMEGL CodeAmounts
      212 alexandria, vaREVENUE4001-359144
      4002-146259
      4003-2151.06
      4004-213906
      4005-17355.4and so on with all codes
      MERCHDSE5000691249.3
      5001106215
      500260490.79
      50032564.59
      5004182390.9
      5050148759.3and so on with all codes

       

      Requirement is to get the ratio at the level of GL code for merchandise or payroll / Total revenue. For Example,

       

      For merchandise , gl code 5000, ratio = 691249.34/650000.I have attached the sample data as well.

       

      JYI, the amounts are coming from a single measure and from same source

       

      Please let me know how I accomplish this scenario.

        1 2 Previous Next