Forum Discussion
Show Non-aggregated value on tooltip in Matrix
Super UserChristaAlen , 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.