How to get averages

[roxys373s]

Hello,

I am having an issue where I am trying to display a chart such as below of the averages of principals for the following categories. The problem is that Qlik is adding all the sums together for the month, such as below, but when I replace the sum formula - Sum({<[category]={'Corporation'}>}[principal]) / 1000000000 - with the average formula- Avg({<[category]={'Corporation'}>}[principal]) / 1000000000

qlik is not producing the correct averages and I'm not sure why. I just know the graph does not look right at all. Any clue on what could be wrong? 

[sidhiq91]

@roxys373s  Could you please provide some sample data for me to work out? And also provide the expected output. That way I know what to work out on?