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

      Hello

       

      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

      1.png

      When adding PRODUCT looks like (TAB2):

       

      2.png

       

      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..

       

      Thanks!