Groupby error

[Anonymous]

Hi,

please give me a solution for the below error..

Trend:

Noconcatenate LOAD

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd )Group by Pro_Tech;

it showing invalid expression ....i have attached qvd data also... urgent

[afurtado]

Trend:

Noconcatenate LOAD

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd ) Group by Pro_Tech  ,  path    ;

[Clever_Anjos]

Your "Group by Section" must have all fields that are not aggregate into your LOAD section

Trend:

Noconcatenate LOAD

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd )

Group by Pro_Tech,path;