Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create a chart based on de pivot table
It would look like this:
Year | Month | TaskType | Days Spent on Project | Days spent on Sales |
2010 | Jan | Project | ||
Sales | ||||
… | ||||
Feb | Project | |||
Sales | ||||
… |
I'm using this formula: if(Tasktype='Sales', sum(DaysSpent). I would present the measures with a line-meter so i would look like mini-barcharts.
Is this possible to do?
Thankx!
Hi.
Perhaps an example will do?
Thx!
I've now solved it using a pivot an using a lineair meter t show the results. No need of a chart or difficult calculations ....