i am struggling trying to write this LOD.
The LOD is equivalent to a table calculation as a % of Total, with 'calculate on' SegmentLabel1 (and filtering away "Overall")
of to simplify, divide each SegmentLabel1 by "Overall" or 9,428,025 / 265,098,436.
_the problem is Overall is an item in this Dimension, so if you just sum the Dimension, it doubles the real value.
_ the view will not look like this, it will be filtered to only show top 3 values
4 answers
Hi, Jon
Thanks for your workbook.
If I understand correctly, you solution should work even though it shows 0 and 1, but if you do a format as shown below, it gives you the percentage
Is that something you expected?
ZZ
