Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
17George
Contributor II
Contributor II

count distinct expression dependent on other columns

Hello,

I have a table with orders, order positions, delivery dates and package id's
As expression should appear the count(distinct) value of the package id
(the yellow number in the pictures below)
and in case the table is full, the sum of all "yellow" numbers

a.jpgb.jpg


Thanks in advance

 

Labels (2)
0 Replies