topic Re: How to sum by distinct item and not by line? in App Development

How to sum by distinct item and not by line?

Anonymous — Mon, 28 May 2018 01:27:08 GMT

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.

Re: How to sum by distinct item and not by line?

niclaz79 — Mon, 28 May 2018 09:11:30 GMT

Hi,

You need to use Sum(ORDER_QUANTITY) to avoid the splitting of lines. The value will then be summed over the selected dimension in this case Vendor Name.

Re: How to sum by distinct item and not by line?

Anonymous — Mon, 28 May 2018 09:17:01 GMT

Ermm okay . I've done that earlier while trying it. Still don't get what I need.

Same expression but differet outcome. Why??