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

    Using LOD Include, but find the subcategory name

    Mick Leahy

      Hi,

       

      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 !

       

      Cheers

       

      Mick