Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table as below:
I'm using an aggregation function in the expression for calculating Company Estimate as a dimension. As you can see, P1 is giving the same aggregated sum twice and splitting the measures. Does anyone have any idea why this is happening? I'm also attaching the app to the post. Thanks in advance!
Change your calculated dimension to this
=num(Aggr(Avg(Aggr(Sum([Cost Estimate]),[Package Name], Supplier)), [Package Name]),'#,###.0')
Change your calculated dimension to this
=num(Aggr(Avg(Aggr(Sum([Cost Estimate]),[Package Name], Supplier)), [Package Name]),'#,###.0')
Hi Sunny. This fixed the issue. Do you have any idea as to why this was happening? Just to know so that I can avoid such things in the future. Thanks a lot again!
I am not sure what caused it...
That's okay. I'll try going through my data model and see if anything looks out of place and might cause this issue. Thanks a lot for the help.