4 Replies Latest reply on May 15, 2018 10:56 PM by Zhouyi Zhang

    Total() function not working

    pavan kumar




      created a calculated field for Percent of Total = sum([sales])/total(sum([sales]))

      then i need to calculate total([Percent of Total])Capture1.PNG

      based on this Total i need to do Formatting (Growth Up arrow and Down arrow).

      I have more complex scenario in my project but here i am showing a simpler version.

      yes i tried window_sum and window_avg functions , they r not giving accurate results


      Plz find attached workbook




      Pavan Kumar