Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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?
May be this?
Sum({<Order = {"=Count (Order)/Count(Item) > 1"}>}Measure)
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.
Would you be able to share a sample or some sample data or provide some more information in some way or the other?
Unfortunately, I can't but when I sort by an expression the way that is filtered now worked.
great