How to get count of similar values from multiple columns?

[#1]

Hi,

Scenario

customers may place more then 1 order in a day for same products

Question

I want to know the count of those orders which contains same product and same customer name and same date.

Data Model (is not normalised) contains following fields :

• OrderID
• CustomerID
• ProductID
• OrderDate

I hope I have explained the scenario properly.

Thanks

[Digvijay_Singh]

Not sure though, may be like this -

Dimension - Date, Customer Name, Product

Expression - If(Count(OrderID>1,Count(OrderID))

[#3]

Thanks.. I will update you on how it goes.