[ASK] Text as popup issue

[#1]

Hi All,

   When we have a more than one dimension, say in a line chart, the text as popup feature displays, when hovered on or more data points at a time, first the dimensions involved, then the expression name = value for each data point and then the data values repeating again. How to set this right?

on one data point :

on multiple data points

The requirement is :

e.g. say if we move on two over-lapping data points, it should show:

Month(dim 1) = Sep-11

Dim 2 = 2.10

Exp = 77,965

Month(dim 1) = Sep-11

Dim 2 = 1.25

Exp = 83,947

Thanks and Regards,

-Karthik

[nathanfurby]

The text pop up functionality is really not very useful other than basic requirements.  The only way that I can think of doing this is to create an extra expression that is only 'Text as Pop-up'.  Then turn off the 'Pop-up Labels' option in the 'Presentation' tab of the chart properties.

You would then have to add lines for all dimension details needed in the expression.  Something like this:

='Month ' = ' & Month & chr(13) & 'Dim 2 = ' & Dim2 & chr(13) & 'Exp = ' & Sum(Field1) & chr(13) & 'Total = ' & Sum(TOTAL Field1)

The downside to this is that when users export to Excel you get a ridiculous column with all of that information tacked on the end.

If you want any Num or Money formatting on the sums then you have to add this into the code.