OBIEE Popup box

Customer wanted to see some extra info in a popup box:

This can be done simple from a narrative view:

First start with a basic report:

goto the narrative view:

Switch on the HTML

in the prefix put:

<tr><th>[b]Customer[/b]</th><th>[b]Revenue[/b]</th></tr>

In the narrative put:

<tr>
<td>@1</td>
<td> <input type="text" onclick="alert('Sum for All Customers: @3!')" value="@2" />
</td>
</tr>

Put it all together on the compound view:

Till Next Time