7 Replies Latest reply on Jun 13, 2014 2:12 PM by Ysaki

    output is coming repeated on the row level

    Ysaki

      Hi All

       

      I have been trying to solve this issue but without success.

       

      the issue is i am viewing that the rows keeps on being repeated. so my report is On Hand Quantity Report.

       

      so the output should be like this

       

      output A

       

       

      Item number                   description            category            sub inventory                 location             On Hand Quantity          

       

      x                                     Red Ball                Soccer                  Adults                        Los Angeles               100

      x                                    Red Ball               Soccer                  Adults                       San Diego                  100
      x                                   Red Ball                Soccer                   Adults                        San Francisco              100
      x                                    Red Ball                 Soccer                 Adults                       Orange County

                   200       

       

      so the total for item x should be 500

       

      the report is coming out in this format

       

      output B

       

      Item number                   description            category            sub inventory                 location             On Hand Quantity          

       

      x                                     Red Ball                Soccer                  Adults                        Los Angeles               500

      x                                    Red Ball               Soccer                  Adults                      San Diego                 500
      x                                   Red Ball                Soccer                   Adults                      San Francisco           500
      x                                    Red Ball                 Soccer                 Adults                       Orange County

              500      

       

      i tried to do the sum but it is still showing me the sum for the hole item by sub inventory

      is it possible to do it like output A ? how can i make it giving me the On Hand Quantity based on the location level

       

      Your suggestions is highly appreciated

       

      Thanks