Display % of total on mouseover

[sergio0592]

Hi all,

I have a stacked graph with % of gender per year of birth. On mouseover, it display %F, %M. e.g for 1990, 30% men, 15% women and i want display 45%. The formula is =count(TOTAL <[Year birth]>Id) / count(TOTAL Id), but i don't know where i can put it for displaying on mouseover. I have tried in label and others places but don't work.

See my .qvw in the attached file.

Regards

[aarkay29]

Will this work??

[ramasaisaksoft]

Hi,

Jean create 3rd expression like First expression name + second expression name  so that this will give sum of the both values but you can disable this expression by clicking the Disable check box.

On Mouse over time you will get the result also for 45%

[rahulpawarb · Accepted solution]

Hello Jean,

Trust that you are doing well!

Please follow below steps:

1. Create 2nd expression with following definition:

//Birth %
='Birth %: ' & Count(TOTAL <[Year birth]>Id) / count(TOTAL Id) * 100 & '%'

2. Deselect Bar and Select Text as Pop-up option present under Display options of Expression tab.

3. Deselect Pop-up Labels option from Presentation tab of chart properties.

4. Apply Number & Show in Percent (%) option from Number tab and click OK.

Please refer attached sample application.

Hope this will be helpful.

Regards!

Rahul

[avinashelite]

add one more expression with the values that's need to be displayed on the hover and un-check the Bar option and check only the show text as pop up that should give the results your excepting ..

Hope this helps you

[sergio0592]

Thanks to all for your helpful anwers.