Forum Discussion
Show Non-aggregated value on tooltip in Matrix
AI am trying to show Non-aggregated value on tooltip in Matrix. My Data table is :
For example if I hover over "AValue" the tooltip should take the value of Table[product3] where Table[Hierarchy 5] == "AValue". So with the table above I wanted to show `2` on tooltip when hovering on AValue in matrix. But its showing total of 2+1+3+5, which is 11
Is there any way to achieve this result. Any help is appreciated.
3 Replies
- amitchandak
Super User
ChristaAlen , Not very clear. But you can create a tooltip. In tooltip page, You can uncheck keep all filter and drop the only filter you want to pass (page property of tooltip page)
Thank You for your reply. To make it more clear, I have removed the tooltip and added it as column (product3) in the below matrix.
Currently it is showing the sum of Product3 values for each row. But what I actually wanted is shown to the right. (ie instead of 11.00 in the first row I wanted to show 2.00, instead of 9.00 in 5th row I wanted to show 1.00).
product3 column in the matrix can be calculated as follows:
1. See what value is shown in the leftmost column of matrix. (For example lets take 1st row, left most column value is "AValue")
2. Now filter the table with [Hierarchy 5] equals to this value. (table[Hierarchy 5] == "AValue")
3. Get the value of product3 column from this filtered table (table[product3] value is 2)
I am struggling to come up with a measure to represent the above logic. It looks very straight forward but I am not able to figure it out.
