Do you want to plot (for example) [Flight expenses] vs [hotel expenses] for each person?
If so you will need to pull those measures out via unique measures:
if [expense]="Flights" then [Expense amount] end
and so on. Create these, put them on your rows and columns and then whatever you want each mark to be on the level of detail (dept, person, etc.)
That did it. Thank you!
I have a question trying to do some thing similar.
How can I categorize sales for previous year, sales four weeks prior and current sales based on date. I would like to display all of the three parameters on the same chart.
I have attached a sample workbook with a report of what I am trying to do.
Thanks for your time.
Example.twbx.zip 373.9 KB