1 Reply Latest reply on May 6, 2013 8:30 AM by Joshua Milligan

    How to keep a higher level value at a lower level detail

    Armando Ramirez



      I have 2 dimensions: PRODUCT and REGION

      and 2 measures: MESOPS and SALES


      At the REGION level we see the following (TAB1 in the attached) where MESOPS equals 6,075


      When adding PRODUCT looks like (TAB2):




      How can I add a measure that keeps value 6,075 for each PRODUCT row, so I can calculate MESOPS(at the PRODUCT level) divided by MESOPS(at the REGION level) ???


      See attached..