Hi All,

I have fact table with granularity up to every line item of the transaction.

CREATE TABLE [dbo].[TrxOrder] (
[OrderID] [int] NOT NULL ,
[OrderDate] [datetime] NULL ,
[ProdukId] [int] NOT NULL ,
[Amount] [smallint] NOT NULL ,
....,
....,
....)

But when drillthrough, I only want to display ''DISTINCT"ly on OrderID.
(One row only for each Order)
How can I do that ?

Thank you for your help,
Krist