Value as Text in Graph

[fred_s]

I'd like to create a couple of Gauges, one per Sales manager, showing their sales results.

Dimension:

=SalesManager = 'Elvis'

Expression:

=Sum([xSales])

It's probably a really stupid question, but I can't find a way to show the value as 'Text in Chart". Text in Chart is no Problem, it's getting the value in there.

So the Sum of xSales for SalesManager='Elvis' in a Gauge

Any help will be appreciated.

Thanks in advance

[#2]

Try something like this in the Text in Chart box on the Presentation tab.

='Sales by '&SalesManager&': '&Sum(xSales)

You need to select Elvis of course to get 'Sales by Elvis: [99999]'

Or did you want a hard-coded 'Elvis'?

[fred_s]

Hi Mark,

Yep, i need a hard-coded Elvis.
I want to create a Gauge per SalesManager.

My Dimension for the the first Elvis Gauge:
=SalesManager = 'Elvis'

The second Gauge will probably be MichaelJackson:
=SalesManager = 'MichaelJackson'

The Needle is in the right position, but i can't get the value in the 'Text in Chart'.

Using "sum(xSales)" doesn't do anything with my 'Elvis Dimension'.

[fred_s]

Attached a simple example.
The real file has no possibility to select a different SalesManager.

The Gauge has a hardcoded Dimension =SalesManager = 'Elvis'.

What i'd like to achieve is to show 1000000 (sales by Elvis) as 'Text in Chart', instead of 2775500.

Anyone?
plz

[matt_crowther · Accepted solution]

Shouold be a simple solution:

Remove the dimension and enter the following as your Expression: =sum(if(SalesManager='Elvis',xSales))

Use the same with your 'Text in Chart' or even ='Elvis Sales: '&sum(if(SalesManager='Elvis',xSales))

That works in your example file and how I've used it in the past.

Hope that helps,

Matt

[fred_s]

It might be a simple solution, but it's exactly what I was looking for.

Thanks a lot Matt!