3 Replies Latest reply on Jul 18, 2018 6:20 PM by Zhouyi Zhang

    LOD returns all zeros

    jon rios

      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