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)

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!

• ###### 1. Re: Calculation to Allocate the Sum of a Measure To Other Dimension Marks (10.2)

HI Jim,

This could be achieved using LOD expressions.

Please find the attached as an example.

Yours,

Yuri

• ###### 2. Re: Calculation to Allocate the Sum of a Measure To Other Dimension Marks (10.2)

Hi Yuri,

This is exactly what I needed; I really appreciate you finding a solution to this problem!

Best regards,

Jim

• ###### 3. Re: Calculation to Allocate the Sum of a Measure To Other Dimension Marks (10.2)

Jim, you're welcome.