display sum as data point above grouped bar chart

[#1]

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.

[#2]

Currently I have this:

Now I just need the sum for each month to be a data point on top. Thanks

[ThornOfCrowns]

Change the Dimension to:

=date(MonthYear,'MMM-YY')

[#4]

Yes, I already did that in edit script and I am using this new variable.

[tresesco]

With my screen shots, make the following changes:

Dimension1: Site

Dimension2: Date(MonthYear,'MMM-YY')

Second expression: =sum(TOTAL <Site> [Store Value])

[#6]

Is the attached what you mean

[#7]

Hmm...now its grouped in site and monthyear:

I'm using 'inv turnover' by the way:)

[#8]

Hi, sorry I can't open the file. Thanks

[#9]

Let me try again

[#10]

Hi,

I think I have achieved it. Please check and if somewhere my understanding is wrong then let me know.

Thanks.

[#11]

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.