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