Chart with Weighted Averages

[#1]

Dear All,

In the attached file, the top chart has weighted averages of balances. In the second chart, when I add Dimension2 in the bottom chart, the individual balances are correct, but they are stacked on top of each other without weighting. The numbers on the axis are higher because the chart is just simply adding up the balances for each individual Dimension2.

Is it possible to have Dimension2 in there but the total matching the total in the top chart?

Will appreciate the help.

[lironbaram · Accepted solution]

check the attach example

[#3]

This is great. Can you shed a little light on how the <month1> argument with the 'Total' function works? Will appreciate it.

[lironbaram]

it make calulate the same total sum in each month for every prevbank look at the table in the attach file