1 2 Previous Next 18 Replies Latest reply on Aug 13, 2019 2:40 PM by Subodh Gupta

    Ranking Top Customer Sales Over Three Years

    Chase Barker

      Hi,

       

      So in the image attached I am essentially trying to sort by the largest total combined sales (which should be the bar chart in orange) for years 2017-2019 and then have it essentially breakdown from in the order of years as it should be reflects (i.e. 2017, 18, 19, etc.). I have a feeling this is an LOD calculation that I need to create or my table calculation is off somewhere. I'm basically utilizing the following dimensions; customer name, invoice year and then my measures are sales. I've created a set that has the top 10 customers sales dollars (picture attached) and then am trying to get it to break down / sort by that aggregate sum of sales dollars.

       

      Just curious if anyone happens to have any insight into how this might be correctly resolved. Thanks much in advance for the help!

        1 2 Previous Next