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.