Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Sub Totals

I have a table which shows our monthly allocation to bonds in different countries over the 18 months. I am trying to subtotal the page by month to calculate the total weight in percent for each month...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks. I don't think I have been clear enough! I am trying to add a new measure so that I would have an additional column in the table call ex cash weight. The measure would take the weight per country (which never sums to 100 because of a small % in cash)  it would then use the total weighting and divide each row by the total figure to get a weight excluding cash. 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

The solution given above is a sample. How do you identify the extral cash weigh? According to the screenshot, only the weight column can be used to calculate the weight. And I don't understand the mean"because of a small cash position this will never add to 100%, so I need to calculate what the ex cash position is by multiplying each bond's weight by the total ex cash position." I will apprecite if you share more details. Thanks a lot.

Best Regards,
Angelia


  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    In order to work out the ex cash position I need to take the total weight 95.73% in the example provided and then divide each country weight by 0.9573 to calculate what each country weight is with the cash percentage removed. In the screen shot provided  I would need to divide 1.38% by 0.9573