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

    Total() function not working

    pavan kumar

      HI

       

       

      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

       

       

      Thanks

      Pavan Kumar