I'm trying to create a straight table chart that shows the weight average FICO for each Product by Outstanding Balance. This calculation
sum(TOTAL <PRODUCT> [FICO] * aggr(sum(OUTSTANDING_BALANCE),[FICO],PRODUCT))/sum(TOTAL aggr(sum(OUTSTANDING_BALANCE),[FICO]))
seems to give an overall total correctly, however, the FICO's I'm getting are 3, 432, and 299 which add up to 734. I'm looking to have the WA FICO on each row (e.g. (I'm making these up...) Product A, WA FICO 732; Product B, WA FICO, 735; Product C, WA FICO 734)
| Product | Outstanding Balance | WA FICO (what I'm getting) | WA FICO (what I want) |
| A | $7,000 | 3 | 732 |
| B | $1,000,000 | 432 | 735 |
| C | $670,000 | 299 | 734 |
| Total | $1,677,000 | 734 | 734 |
