Mouse over

When you place your mouse on a dimension value in a chart, you can get more or less detailed information as shown above, so we are going to look at a few advanced options.

One option could be to show if Units Sold for the managers is above or below the average Units Sold.

mceclip0.png

Open the advance text editor again.

mceclip1.png

We can combine placeholders for values with fixed text. Here we use two placeholders from the drop-down list, {RowMember} (Sales Manager) and {Value1} (Units Sold) and a fixed “is”.

Now we insert a conditional text (If – Then – Else). Click the drop-down arrow and select <New conditional text>

mceclip2.png

Remove the number 1 in the “if” statement box and select Value1 in the drop down menu.

mceclip3.png

Then enter the formula for testing if Value1 (Units Sold) is greater than Column.avg (Average). Next, click Apply.

mceclip4.png

Enter the text in the “Then” box. Click Apply.

mceclip5.png

Next, click Else if to enter a text for the values that are less than average.

mceclip6.png

Now enter the text “less than average” and click apply

mceclip7.png

mceclip8.png

mceclip9.png

Next, we create a new cross table with a comparison and a calculation in it.

mceclip10.png

With a few adjustments, we get a result like this:

mceclip11.png

We want our mouse over to show combinations of fixed text and values for our comparison, our growth calculation and our dimension values.

We open the advanced text editor right away:

mceclip12.png

We type “Result for:” and select {RowMember} (Sales Manager).

Nest, we type “Growth:” and find {Value2}, which we can see from the drop-down, is Growth Percent Revenue.

We type some more prefixes “Last year to date:” and “Year to date:” and finally find <New lookup for Revenue>

mceclip13.png

We select this lookup twice and get the following result:

mceclip14.png

When we added the first lookup value, we got an extra tab in our diagram menu:

mceclip15.png

The Revenue1 placeholder should point at the column with data for last year to date. The data is in the first column if we look inside the cross table.

mceclip16.png

Revenue2 should point at column2 which shows the data for this year to date.

mceclip17.png

mceclip18.png

Was this article helpful?
1 out of 1 found this helpful

Comments

1 comment
  • Perfect explanation except I can't seem to select any columns data unless the column is visible. e.g.

    Lookup values
    Revenue1
    Value Drop Down - doesn't list column if is not visible.

    I made the column visible and added OK and then added to mouse over but then when I make the column not visible the mouse over changes.

    0

Please sign in to leave a comment.