Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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'?
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'.
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
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
It might be a simple solution, but it's exactly what I was looking for.
Thanks a lot Matt!