2 Replies Latest reply: May 28, 2018 5:18 AM by Lau Zhenjie RSS

    How to sum by distinct item and not by line?

    Lau Zhenjie

      Hi all, as my excel data I am trying to show distinct purchasing document (PD) and then the sum of that order quantity of that particular PD. Then the sum will be categorize as belong to Below 3,001, Between 3,001 - 10,000, Between 10,001 - 30,000, and Above 30,001.

       

       

      I am able to Count(Distinct(Purchasing_Document)) for Total Number of PO. For categorizing, I am confused as it only detect each line. By right, supposed 1450+8480+22625+6380 = 38,935 and belong to Above 30,001 and count as 1.

      This is how I come up with the category.