topic Re: Count Distinct on the dimension and the stamp the count on the lowest order number in App Development

Count Distinct on the dimension and the stamp the count on the lowest order number

RajeevaM061 — Thu, 14 Oct 2021 17:12:28 GMT

Need your help to Count distinct values on the dim “ Package Pattern” w.r.t each invoice number and stamp the number based on the lowest order number in the sheet.

For Example : For the Invoice “ 1111”, I have 1 distinct package pattern and need to stamp the count on the lowest order number in the table . In the below example, it’s 3rd row since 5 is lowest order number for the specific invoice.

Sales Invoice No	Order Number	Package Pattern
1111	10	Part A, Part B, Part C
1111	25	Part A, Part B, Part C
1111	5	Part A, Part B, Part C
1111	30	Part A, Part B, Part C

Expected result :

Sales Invoice No	Order Number	Package Pattern	Sequence Qty
1111	10	Part A, Part B, Part C	0
1111	25	Part A, Part B, Part C	0
1111	5	Part A, Part B, Part C	1
1111	30	Part A, Part B, Part C	0

Thank you !

Re: Count Distinct on the dimension and the stamp the count on the lowest order number

Digvijay_Singh — Fri, 15 Oct 2021 03:11:26 GMT

Something like this may be -

Expression used is -

Coalesce(Aggr(Count({<[Order Number]={$(=Min([Order Number]))}>}1),[Sales Invoice No],[Order Number]),0)

Thanks,

Re: Count Distinct on the dimension and the stamp the count on the lowest order number

RajeevaM061 — Fri, 15 Oct 2021 21:02:49 GMT

Thank you so much ! .. it's working