You may try a pivot table chart. An example is attached.
this is exactly what I was trying to do myself too....
I'll have to figure out what you exactly did, because when I try to reproduce the pivot table myself, it remains empty :-)
How did you define the blue and the red color? (I suppose it indicates the trend (up/down))
Thanks a lot!
Very fast, and straight to the point!
I also got an empty pivot table.
In order expand the pivot table, I selected a person and time
Then moved the time dimension to columns by dragging it above the result.
To set color, click on the sign near the Result in expressions tab, and set the Text color in the 'Definition' box on the right.
Hope this helps.