Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how do I sum up the 'inv turnover' (see in attached sample data) for each month and display it as a data point above the grouped bar chart like below? Each bar represents each site(see in attached sample data). Thanks.
Hi, so sorry I can only open files I created myself as I'm using Personal Edition. Do you mind sending me screen shots instead? Thanks so much.
Hi,
In this, I have taken 2 dimensions, firstly "Month(MonthYear)&'-'&Mid(Year(MonthYear),3,4)" i.e. MonthYear and then Site. Then I have taken 2 Expressions:
1st one: "Sum: sum([inv turnover])"
2nd one: "Total: =sum(TOTAL<MonthYear>[inv turnover])"
So, in the chart, bar is displaying inv turnover for each Site for MonthYear and dot represent total turnover for each month i.e. why i have grouped it by MonthYear.
Thanks.