I've got a pivot table with the below structure, showing tasks per country and year created. The year is gotten with dimension "=Year(CreationDate). The count is done with expression "=Count(ID)".
Country / Year
2011
2012
2013
Sweden
2
4
2
Norway
3
2
4
Finland
2
2
5
Some tasks have a status called "Cancelled". Now I wish to show these both under the year created AND under the year cancelled, see example below (ie. the 2 showing as Cancelled also appear under the year they were created).
Country / Year
2011
2012
2013
Status
Created
Cancelled
Created
Cancelled
Created
Cancelled
Sweden
2
4
2
Norway
3
2
4
2
Finland
2
2
5
I'm not sure how to accomplish this. I can easily do a sum of those with cancelled status, but they then show under the year created. I want them to remain there but also that they show under the year cancelled. Can anyone help with this please?
Thanks for your reply! This example however moves the Cancelled tasks so that they are only shown under the Cancelled year, they should still be shown under Created year as well. But Bill provided a working solution, thank you both!
