Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table of deliveries where each delivery can have multiple parts on it. I want to create a drill through company to part that counts the deliveries as distinct relative to the dimension. Deliveries are not split at a company level, but are at a part level.
I have produced a QVW of what I want to see, but it is hard coded with if(GetCurrentField(), which is not ideal because in my live document I use a dynamic drill the user can change the dimensions should they wish.
Is there a better way?
hi
may be i am missing something
but why not use a simple
count(distinct Delivery)
Thanks for the response Liron. I've amended the Drill table to show why. I need the Delivery Count column to be replicated, but I can't get this with a simple Count(Distinct()). On the company level one field is correct, but on the part level the other is correct.
hi Matthew
i think the correct total from business perspective should be 2 even
when you look at part as dimension because you really have only 2 deliveries and not 5
i didn't manage to see a problem in the new model, what were you refering to?