'How to properly display an attribute as value in a matrix?
I have a hierarchy which is a bit mixed, using columns from different Dimensions. The hierarchy is:
Name
Parent
Client Sold
Client Pay
Contract.
I am displaying them in a matrix visual.
As 'values' I have some measures from the Fact table. Now, I have as a requirement to show the ‘address’ of the 'Client Pay' as ‘Values’ too
As expected, the problem is that the data only makes sense if I drill down to the ‘client pay’ level… otherwise when aggregated of course it just picks the ‘first address’ and makes no sense.
Is there a way to show blank, until the user drills down at the ‘client pay’ level?
(I am consuming a lot of data, so I was looking for an optimal way of achieving this…)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
