Skip to Content
avatar image
Former Member

Show Calculated Row/Field on Chart

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 22, 2010 at 04:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded