Cube in report studio--- please help

[sravantig]

I'm trying to create a line chart... from a cube(in source tab)
x axis--- years
y axis--- turnover rate
series--- managers, associates

i want to show the turnover rate for the complete ABC company for few years.

My QUESTION is... can I combine managers and associates as one and insert in series? please help me.. I'm a newbie

[absriram]

You have to create 2 queries, one for managers and one for associates. Union these two queries and then create the chart based on the union.

Sriram.
http://www.cognosonsteroids.com