3 Replies Latest reply on Jun 26, 2019 11:20 AM by Jiaqi Zhang

    How to show share percentage  for specific platform for everyone usingLOD

    Jiaqi Zhang

      I am trying to show share percentage, in this case, Jante's sales / department sales on platform level with platform C and D. In my real data set there will be more people and everyone might have different highest and lowest sales platform. I want to show the share percentage for the highest and lowest platform for everyone. I am really new to using LOD and this is what i have

       

      {include [Highest AUM Platform]:sum([Janet's sales])}/{include [Highest AUM Platform]:sum([department sales])}

       

      but its not giving me the right number. Can someone help me?

       

      I also attached the workbook if that makes it easier