Stack Graph - Grand Total

[Atif]

Hi, I am using Pivot Chart view (Stack Bar) of a Crosstab Query to display
Yearly Sales by Quarter:

Year Q1 Q2 Q3 Q4
2007 10 15 12 8
2008 15 20 10 10

can i display Grand total of each year on Top of earch bar.
any suggestion/alternate welcome.

 

[NeonSky via AccessMonster.com]

Hey Atif,

Create a new query, bring in your existing query to the query (same as adding
a table but you are adding a query instead), add the year field, add the "Q"
field, Click the Totals button (Looks like an "E" or a Greek Sigma on the
toolbar). You should now see "Group By" for both of your fields. For the "Q"
field, click the drop down box where it currently says "Group By" then select
sum. Run the query. This should you give you your totals by year that sums
all "Q's", title this field "QTotal". Save the query. Next create a another
query. Bring in both your original query and your new query, create a inner
join on the year field. Bring down the "Q" field from your original query
which should display all the Q's individually, then bring down your "QTotal"
field, when you run the query the individual "Q" values should display along
with the "Sum".