Show only totals in a bar chart (or pie chart)

[#1]

Hello,

Is there any way to display a chart with *only the totals*  of calculated expression columns? 

The chart has one dimension and 3 expressions (I have to retain the dimension for the expression calculations to work) .

I'm sorry I cannot really post the table at this point.

I found one expression that seems to work... but becuase I have 10,000+ rows of data, it takes too long to process each time.... here it is

BOTTOM(RANGESUM(RANGESUM(column (2)), ABOVE(RANGESUM(column (2)), 1, ROWNO())))

***

I can also *almost* make this work by displaying only one 'max visible number' from the Bar Chart / Presentation Tab, but still you get one row showing and then the total....

Thanks!

[CELAMBARASAN]

Hi,

     Try with this expression

     If(Rowno()=0,Sum(Field))

     Celambarasan

[jagan · Accepted solution]

Hi,

Use this expression

=If(Rowno()=1,Sum(TOTAL Amount))

Using TOTAL in the expression will give you the overall Total.

Regards,

Jagan.

[#4]

Worked great!  Thanks.