Forum Discussion
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...
Can you please post the sample data/data model if possible.
Here is an easier version of what I am trying to do. I have a total allocation to bonds in each country which totals 95.73%, the remaining 4.27% is cash. I need to divide each position by 0.9573 to work out the position excluding cash. I can't work out what syntax will get the correct answer.