Showing Crosstab Totals Column in Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following crosstab query. I'd like to be able to put the Total Of
Amount on the secondary axis, but I can't figure out how. I appreciate your
help.

TRANSFORM Nz(Sum(Sales_All_qry.Amount),0) AS SumOfAmount
SELECT Sales_All_qry.Salesperson, Sum(Sales_All_qry.Amount) AS [Total Of
Amount]
FROM Sales_All_qry
GROUP BY Sales_All_qry.Salesperson
PIVOT Format([SaleDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
 
What is the exact Row Source property SQL view?
Is your chart set up to show months on the X axis and Amounts on the Y axis?
What value do you want to display on the secondary axis (the total for a
sales person)?
 
Back
Top