3 Replies Latest reply on Apr 17, 2018 1:30 PM by Yuriy Fal

    Calculation to Allocate the Sum of a Measure To Other Dimension Marks (10.2)

    Jim Palecek

      Given the chart below representing my simplified data, I would like to know if it is possible to allocate the Cost from Project E to Projects B, C and D by Month and hide Project D from the visualization. The costs should be allocated based on the percent of total for Projects B, C and D.

      Project A is out of scope for the calculation, but still displayed on the report.

       

      For Month 1 of 2018:

       

      Project B = $200 (40% of 500)

      Project C = $200 (40% of $500)

      Project D = $100 (20% of 500)

      ----------------------

      Total = $500

       

      Project E = $250

       

      The chart below shows the desired result.

       

      Project B = $200 + (4o% of $250)  = $300

      Project C = $200 + (4o% of $250)  = $300

      Project D = $100 + (2o% of $250)  = $150

       

      Thank you!