Count of fields

[kushalthakral]

Hi All

i have a following requirement below

Campaign	Customer	Years with Company	Count
A	1	8	9
A	2	8	9
A	3	8	9
A	4	8	9
A	5	8	9
A	6	8	9
A	7	8	9
A	8	8	9
A	8	8	9

i need to calculate the count of customers and display in a separate column

as in the case above it is 9 which includes duplicate also need to consider that also

Can any one help me on this

Thanks

Kushal

[swuehl]

Table:

LOAD Campaign, Customer, Years

FROM...;

JOIN

LOAD Count(Customer) as Count

RESIDENT Table;

[swuehl]

If you are not looking for a script solution, you would need to define the exact context in which you want to create the column.

Again, it's much easier to help if you create and post a small sample QVW.

Regards,

Stefan

[maxgro]

you can try with TOTAL in a chart

count(TOTAL Customer)

or by Campaign   

count(TOTAL <Campaign> Customer)

[susovan]

Hi Kushal,

PFA

Try this

You also try this way,

[kushalthakral]

Hi All

i have solved this by using below formula

Sum(Total<[Years with Company],[Campaign Name]>Aggr(Count(Total<T>distinct T),[Campaign Name],T))