This content has been marked as final.
Show 5 replies

Re: urgent help: how to calculate the sum of a calculated sum
Sunny Talwar Jun 14, 2017 12:11 PM (in response to Xiaoyu Yang)What happens if you add Month to the Aggr dimension
Sum(Aggr(Sum([Delivery Quantity])*[copper weight / part], [Supplier],[Part], Month))

Re: urgent help: how to calculate the sum of a calculated sum
Xiaoyu Yang Jun 16, 2017 2:25 AM (in response to Sunny Talwar )Till doesn't give me the right answer...same result as my function above.

Re: urgent help: how to calculate the sum of a calculated sum
Sunny Talwar Jun 16, 2017 4:35 AM (in response to Xiaoyu Yang)Based on the data you have provided above, what is the expected output you are looking to get?



Re: urgent help: how to calculate the sum of a calculated sum
Rupam Das Jun 14, 2017 12:20 PM (in response to Xiaoyu Yang)If your dimensions in Pivot table is Supplier, Part and month
Then only this expression should work 'Sum([Delivery Quantity])*[copper weight / part]'.
If not working than I am missing something.

Re: urgent help: how to calculate the sum of a calculated sum
Xiaoyu Yang Jun 16, 2017 2:24 AM (in response to Rupam Das)This gives me only when I select a certain part. Because each part has different copper weight and silver weight, it isn't able to give me a total.
