issue to display third synthetic dimension with Aggr

[Raju_123]

Hi Experts,

Below is the expression that i am using to display proposed budget, revised budget and actual _expenditure

pick(match(No,1,2,3),
sum(aggr(sum(distinct{<[SUB_PROJECT]-={'-'}>}[PROPOSED BUDGET]),[SUB_PROJECT],[MAIN_PROJECT])),
sum(distinct{<[SUB_PROJECT]-={'-'}>}[REVISED BUDGET]),
Sum(aggr(sum(distinct{<[SUB_PROJECT]-={'-'}>}[Actual_Expenditure]),[SUB_PROJECT],[MAIN_PROJECT])))

First two are displaying with values but unable to display the third value.

i have used no distinct after the aggr then it display the third value but the value is wrong.

Please help how to resolve the issue.

[Usama]

Hi,

Can you please attach sample data. So it would be easy to sort out.

Thanks