Set Analysis vs Aggr to find multiple orders in a single day

[mikelees80]

So i trying to identify when a customer as had a order shipped to them on the same day but with different deliver order numbers

Example Table

Highlighted in Yellow are the deliveries we want to count becuase that customer recieved more than deliver that day

I've tried various set analysis and Aggr function but i just can't get it to work

Customer	Delivery Header Number	Delivery Line Number	Delivery Date	Month
A	1	1	27th jan	Jan
A	1	2	27th jan	Jan
A	2	1	28th Jan	Jan
A	2	2	28th Jan	Jan
A	3	1	28th Jan	Jan
A	4	1	28th Jan	Jan
A	4	2	28th Jan	Jan
A	5	1	28th Jan	Jan
A	5	2	28th Jan	Jan
A	6	1	29th jan	Jan
A	6	2	29th jan	Jan
A	7	1	27th mar	mar
A	7	2	27th mar	mar
A	8	1	28th mar	mar
A	8	2	28th mar	mar
A	9	1	28th mar	mar
A	10	1	28th mar	mar
A	10	2	28th mar	mar
A	11	1	28th mar	mar
A	11	2	28th mar	mar
A	12	1	29th mar	mar
A	12	2	29th mar	mar
B	20	1	27th jan	Jan
B	20	2	27th jan	Jan
B	21	1	28th Jan	Jan
B	21	2	28th Jan	Jan
B	22	1	28th Jan	Jan
B	23	1	28th Jan	Jan
B	23	2	28th Jan	Jan
B	24	1	28th Jan	Jan
B	24	2	28th Jan	Jan
B	25	1	29th jan	Jan
B	25	2	29th jan	Jan
B	26	1	27th mar	mar
B	26	2	27th mar	mar
B	27	1	28th mar	mar
B	27	2	28th mar	mar
B	28	1	28th mar	mar
B	29	1	28th mar	mar
B	29	2	28th mar	mar
B	30	1	28th mar	mar
B	30	2	28th mar	mar
B	31	1	29th mar	mar
B	31	2	29th mar	mar

Example Pivot Table Output

	Layout 1
		27th jan	28th Jan	29th jan	27th mar	28th mar	29th mar
Customer	A	0	4	0	0	4	0
	B	0	4	0	0	4	0
	layout 2
		Jan	Mar
Customer	A	4	4
	B	4	4

[sunny_talwar]

I am not sure I understand the logic behind picking only the yellow rows. Would you be able to elaborate a little bit more?

[mikelees80]

Hi Sunny

All i was trying to do was highlight that customer A on 28th Jan had 4 orders and 28th March had 4 orders

These are are orders i need to count, if customer A has only had 1 delivery on a single day then i am not interested in counting it

[sunny_talwar]

So, it seems like something like this should work...

If(Count(DISTINCT [Delivery Header Number]) >= 2, Count(DISTINCT [Delivery Header Number]))

[sunny_talwar]

Something like this (Image and sample app attached)