on 06-21-2010 3:31 PM
I have a table which shows 3 rows and 2 columns and a sum row at the end. I have turned it to a chart I find the 3 rows on x-axis. My question is it possible to show the sum/ calculated row also as an element on the charts x-axis.
Example
Col1----
> Col2
Gross Sales----
> 4
Discount----
> 1
Return----
> 1
-
Sum (Net Sales)----> 2 (4-1-1)
When I turn this table to a chart I get the 3 rows (gross sales, disc, ret) on the x-axis. Is it possible to get the 4th calculated row on the x-axis of the chart .?
Thanks & Regards
Ishaq
Edited by: Ishaq Baig on Jun 21, 2010 4:34 PM
One trick that has worked well for me in the past is to create a union query with a dummy value for the Total. So you get this:
select Y, sum(Z) from tables
union
select 'Total', sum(z) from tables
This creates data in four rows, rather that treating your total as a sum it becomes part of the data. Then you can chart it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.