Total of Shipments with additional dimension

[#1]

Hi all

I need an analysis that shows me Numbers of Shipment. Therefore I have to count delivery dates by Shipping Adress.

How can I do this? How can I add the dimension "Shipping Adress" in the formula "Count (Distinct Fact.Date_Delivered)"

thanks for your help

Oliver

[sbaldwin]

Hi, if i understand you, you would add a calculated dimension using the AGGR funciton, ie:

AGGR( Count (Distinct Fact.Date_Delivered)  , "Shipping Adress")

[#3]

Insered this formula:

AGGR(Count (Distinct Fact.Date_Delivered), Customer_Sales_Role.Address)

the result is 0 ... but I don't think there is a formula error...

This is how it looks in Excel:

I have an Adress and I have to count the Shipment Date...

Thanks for your help