Multiple expressions on bar chart

[#1]

I need to do a revenue by week bar chart, where the revenue is categorised by department to show a stack bar chart and where the user can filter by one or more departments.

The problem I have is that 'Department' isn't actually a field, therefore I can't simply add it as a 2nd dimension.

Each Department is defined by certain DESKS and SECTORS

I have been able to do a set analysis for each expression, which gives me a stacked bar chart but the issue is that I have no DEPARTMENT picklist my users can filter by if the only want one departments revenue figures displayed.

I thought about have one expression in the chart and then defining each department with a bookmark and having those bookmarks available to the user as an object on the page, but this doesn't enable the user to select multiple departments.

How do i get round this issue?!

thanks very much

alex

[Gysbert_Wassenaar]

The best way is to create the Department field in the script so you can use it as a dimension in your chart. Or perhaps you can try this approach: Users can map/group dimensions at run-time!