Sorting People under Departments

[#1]

Hi,

I have a graph with a group of sales people that i need sorted under their departments. I have a previous post on this but I now need to take it further so I am opening an new question.

I need the graph to be sorted with the sales/person and then group all the sales people per department. I need both names of person and department showing, and i need to show only the people that actually belong to an department to show up there. I have a pivot table set up and i really just need that table to be shown as a graph.

Cheers,

[Gysbert_Wassenaar]

See attached qvw. That's the best that's possible afaik.

[#3]

tnx, but i still need to tell the departments apart somehow,preferably with colors. any ideas on that?

[Gysbert_Wassenaar · Accepted solution]

Create an expression that calculates a coloer per department. Click on the + in front of the expression, select Background Color and enter an expression. For example color(FieldIndex('Department',Department))