Pivot Table vertical and horizontal summing

[#1]

Hi there

I have a problem with the calculation in a pivot table.  I need to sum a column (MG Value) vertically, but instead it’s taking into consideration the other dimensions.  In my example here “% of Total MG Value” should sum up to 100% but instead it’s see’s two dimensions and dividing this between the two (49.73% + 50.27% = 100%).  Where both of them should have been 100% on their own.

Im attaching a reduced data model for you.

[tresesco]

You have PortfolioPeriod in dimension rather than PortfolioYear, in that case, try :

sum([Total Portfolio Value]) / sum(TOTAL  <FundName, PortfolioPeriod >  [Total Portfolio Value])

[#3]

And yet again, it solves my problem.  Im sorry, that was a rookie mistake.  .

But thanks for you help !!!