If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Showing Crosstab Totals Column in Chart
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"); |
#2
|
|||
|
|||
Showing Crosstab Totals Column in Chart
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)? -- Duane Hookom Microsoft Access MVP "Alex" wrote: 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"); |
Thread Tools | |
Display Modes | |
|
|