display informtion when hovering over croostab expression

[curiousfellow]

I created a crosstab reporting average numbers. I would like to show additional information when hoovering over a number . For example the number of respondents to a survey.

Can not find an option like that. Is it possible ?

[awhitfield]

Hi Curious,

you can use text popup, see the attached example where it's used on a bar chart.

Andy

[curiousfellow]

I did find that option for a chart, but there is not such option fot a crosstab

[awhitfield]

What do you actually mean by a CrossTab?

Andy

[awhitfield]

I  presume you mean a pivot table, you can't do it by hovering over one of the 'normal values' , but if you convert the supplied example, to a pivot, you can see that you get an extra POP column, that you may be able to utilise.

Andy

[stigchel]

I use the total row of the table for that with a condition in the expression you can specify a different calculation e.g. something like

if(Rowno()=0 and Dimensionality()=0,'n='&Count(ID),YourExpression)

An other option is to add the n= expression to the label of the expression you are using, so it is showing in the header.

(Next to adding new columns with an extra expression offcourse)

[curiousfellow]

Sorry I mean a Pivot Table. I try to avoid extra columns and the "hoover value" has to be presented and calculated  for every "normal value"

@Andrew, which supplied example are you reffering to ?

[awhitfield]

There's a qvw attached to my original reply

[stigchel]

No you can't without the extra columns (no hoover). Using my option it would like something like this

N.B. Werk je voor een marktonderzoekbureau?

[ali_hijazi]

add the desired text to the comment of each expression: