4 Replies Latest reply on Sep 14, 2016 9:11 AM by Kyle Boyce

    Pie chart implementation



      I have products and sales records. My requirement is to have how much percentage is occupied by each and every products.


      Product   Sum( Sales)     Percentage

      A               40                    40%

      B               10                    10%

      C               15                    15%

      D               25                    25%

      E               10                    10%


      I am getting above data, but when I filter on Product A, then I am getting Sum Sales is 40 but my percentage shows 100% which I don't want. Even if I filter on A it supposed to show 40%.


      but not sure what trick should be used here.


      And same data I want to get it in a pie chart format as screenshot attached.