Forum Discussion
Sub Totals
Hi Anonymous,
In your given screenshot, which column can be used to display the ex cash position? The weight is used to calculate the percent for each contry in each month, right?
You'd better create a calculated column, can create measure like the following formula.
Month=MONTH(Table[Valuation Date])
Measure:=CALCULATE(SUM(Table[Weight]),ALLEXCEPT(Table[Country of risk]),ALLEXCEPT(Table[Month]))
Best Regards,
Angelia
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.
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,
AngeliaIn 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