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");
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");