Finding all the Speed which is sold by all partner on same date

[#1]

Hi

Date	Speed	Partner	Quantity
20-05-2016	5000rpm	ABC	100
20-05-2016	7200rpm	XYZ	100
20-05-2016	7200rpm	ABC	200
20-05-2016	5000rpm	XYZ	200
20-05-2016	5000rpm	PQR	300
21-05-2016	18000rpm	ABC	300
21-05-2016	5000rpm	PQR	400
21-05-2016	7200rpm	ABC	500
21-05-2016	7200rpm	PQR	500

I need to find which speed is sold by all the partners whose Quantity is greater than zero on the same data.

From the above example answer is 5000rpm.

Any solution for the above question?

Thanks

Piyush

[Kushal_Chawda]

What will be your dimension?

[#3]

I need to create a dimension from this if the above condition is matched then only i will show the speed ie. 5000rpm in dimension?

[Kushal_Chawda]

Create Straight table

Dimension:

Speed

Expression:

Quantity

=if(sum({<Speed={"=count(distinct Partner)=count(Total distinct Partner)"}>}Quantity) >0,

sum({<Speed={"=count(distinct Partner)=count(Total distinct Partner)"}>}Quantity) )

or just this expression will work

sum({<Speed={"=count(distinct Partner)=count(Total distinct Partner)"}>}Quantity)

Update: Need Count(Total distinct Partnet)

[sunny_talwar]

May be this in a text box object

=Concat(DISTINCT {<Speed = {"=Count(DISTINCT Partner) = Count(TOTAL DISTINCT Partner)"}>}Speed)

[#6]

Thank for your reply,

I have added one more row in the table (Last row) for 7200rpm which is sold by all the partners but on different dates. So this should not be considered?

[#7]

Thank for your reply,

I have added one more row in the table (Last row) for 7200rpm which is sold by all the partners but on different dates. So this should not be considered?

[Kushal_Chawda]

It will be considered as expression is

{"=count(distinct Partner)=count(Total distinct Partner)"}

So in this case, count(distinct Partner) =count(Total distinct Partner) =3, so do you want this row or not?

[sunny_talwar]

But then 5000 won't be considered as well because it is not all in one day, right?

[Kushal_Chawda]

try adding dimension Date as well in straight table