Count First Sorted Value

[#1]

Hi,

I have this initial situation (Attachment below)

Per Customer (third column "Kunde") I have several Actiontypes (Column "Aktionstyp") with the Date (Column "Datum").

What I want is to count the Customers with the first ActionType. In the attachment the first Action Type for the Customer 640068 is "2 - Telefonat", for the Customer 640069 "6 - Besuch"

The result should look like this:

Action Type          Count Customers

2 - Telefonat                    1

6 - Besuch                      1

How can I count the customers per first Action Type?

Thanks in advance

[arjunkrishnan]

Let Pls Attach Ur Xls or Qwv ...Thats Useful to Workout as

[mdmukramali]

Dear,

if your using Action Type as dimension then directly you can use count(Customers).

if you need something else can you attach the sample file.

Thanks,

[#4]

Okay, here is the QVW.

I have selected two customers, but the result should capture all customers.

@Mohammed: Yes, I want to use "Action Type" as dimension, but there are many Action Types for ONE customer, I only want to see the Action Type with the min date, the first date.