i am working with a Dimension that includes an Item that is a Sum of all the other items in this specific Dimension. If i try to SUM () this Dimension its value is doubled (since the dimension already includes a item for the total) labeled "OverAll"
i am trying to write a calculation that just takes this specific value, "Overall" to use in other calculations (like each items as % of Total). here is a screenshot, any insight to isolate this value? thanks
max(sum(if segmentlabel1 = "Overall" then [Measure value] end)) - This calc will help you