How to exclude records?

[Anonymous]

Hi,

I have a pivot table that will display the number of orders and the items related to that order. for example order 10001 has 3 items10001-001, 10001-002 & 10001-003.

What I am trying to do is only displays the orders with more than 1 item related.

How can I do that?

[sunny_talwar]

May be a calculated dimension like this

Aggr(If(Count(Item) > 0, Order), Order)

or a set analysis like this

Sum({<Order = {"=Count(Item) > 0"}>}Measure)

[Anonymous]

Doesn't work, I need something like

Count (Order) / Count (item) >1

But if I expand it the total will be 1 and this won't work, am I right?

[sunny_talwar]

May be this?

Sum({<Order = {"=Count (Order)/Count(Item) > 1"}>}Measure)

[Anonymous]

Nope, if I use that function will show the table as blank, because when I expand a Order the total will change to 1 and I think it is failing 'cause of that.

Thank you for your effort.

[sunny_talwar]

Would you be able to share a sample or some sample data or provide some more information in some way or the other?

[Anonymous]

Unfortunately, I can't but when I sort by an expression the way that is filtered now worked.

[sunny_talwar]

great