1 2 Previous Next 15 Replies Latest reply on Nov 5, 2018 10:22 AM by f ada

# tooltip show max sales city

Hi mates,

I want to show in my graph's TOOLTIP,

maximum sales city ( the city NAME that makes the maximum sales)

(my table is like that)

CITY   SALES   MONTH

how can I write the code in the tooltip of my graph? do I have to make calculated field first?

thank you!

• ###### 1. Re: tooltip show max sales city

Create this Calc:

{MAX(IF {MAX(Sales)}=Sales Then City End)}

Drag it to Tooltip

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 2. Re: tooltip show max sales city

I think this works but , I have another dimension here MONTH,

I need to sum the sales of city first,   then get the max.

(first group by the city sales sum, then get the max)

for ex :

Aberdeen   10

Aberdeen   15

Abilene       20

here I need :

Aberdeen (bec sum is 25)

but your code gives me :

Abilene (because it is max (20) among records)

• ###### 3. Re: tooltip show max sales city

Thanks

Deepak

• ###### 4. Re: tooltip show max sales city

But here there is a problem,

My table is like that;

CITY   SHOP SALES   MONTH

Here my aim is to make a map and,

to see the max sales shop of each city in tooltip in map.

I tried to apply the calc. fields but tihs code shows the only max :

{MAX(IF {MAX(Sales)}=Sales Then City End)}

I need it to change for each city.

• ###### 5. Re: tooltip show max sales city

{FIXED City:MAX(IF {Fixed City:Max(Sales)]=Sales Then City End)}

• ###### 6. Re: tooltip show max sales city

gives syntax error

• ###### 7. Re: tooltip show max sales city

also as I told above my table is :

CITY  - SHOP -  SALES  -   MONTH

I want to see on the map (when I go on the cities) tooltips :

maximum selling shop of each city

• ###### 8. Re: tooltip show max sales city

Please attach some workbook or data if this doesn't work

{FIXED City:MAX(IF{Fixed City:Max(Sales)}=Sales Then Shop End)}

1 of 1 people found this helpful
• ###### 9. Re: tooltip show max sales city

Yes! that works.

can we do it for not only the maximum, but also for second and third rank shops?

• ###### 10. Re: tooltip show max sales city

Thanks

Deepak

• ###### 11. Re: tooltip show max sales city

I wanted to do it but, I could not find how to do it CORRECT.

In the action button it does not exist.

• ###### 12. Re: tooltip show max sales city

• ###### 13. Re: tooltip show max sales city

I still cna not find it . It should not be that hard!!

Can you show print screen of it?

• ###### 14. Re: tooltip show max sales city