Hi,
My this query I created is presenting department wize employees including all nationalities.
There is a dept called "Top Management" which I dont want to appear in my graph therefore I was modifying the above query using <>"Top Management" but it says "You can't specify on the same field for which you entered value in the cross tab row"
Any help?
My this query I created is presenting department wize employees including all nationalities.
Code:
TRANSFORM Count(T_JobOffer.[CDept]) AS CountOfCDept
SELECT T_JobOffer.[CDept]
FROM T_JobOffer
GROUP BY T_JobOffer.[CDept]
ORDER BY T_JobOffer.[CDept]
PIVOT T_JobOffer.[CNationality];
There is a dept called "Top Management" which I dont want to appear in my graph therefore I was modifying the above query using <>"Top Management" but it says "You can't specify on the same field for which you entered value in the cross tab row"
Any help?