6 Replies Latest reply on Aug 24, 2016 6:29 AM by Jonathan Drummey

    Using LOD Include, but find the subcategory name

    Mick Leahy



      I'm using the LOD include to work out the % of the highest sub category for my category as follows


      Sales of Sub Category = {INCLUDE [Sub Category]: sum([Sales])}


      % of Largest Sub Category = max([Sales of Sub Category])/sum([Sales])


      This works fine and in my Viz I have the category and then show the %.  What I woul also like to reflect is the name for this sub category as well, but can't find how to reflect - so any help appreciated !