Distinct(count)

[#1]

Hi,

So the above is what I have right now. The bottom table is fine, but I need to change the first one. Instead of counting how many days were spent in each status, I want to count how many sales doc #s spent any amount of time in those statuses. For example, if 10 sales doc spent 2 days each in Delivery Block, it would say 10 next to delivery block. I was trying to use aggr and count but I am having trouble getting the expression right. The first one is a straight table and the second is a pivot table.

Thank you!

[swuehl · Accepted solution]

Maybe

=Count( Distinct [Sales Doc.])

[#3]

I definitely over thought that one. Thank you!