This should be possible.
Could you share a sample set of data to tinker with.
I cannot share any of the data, as they are sensitive
However, I can provide a very small dataset that represents the original. Is this ok?
Thank you for your time.
PS: I attached the file in the original post
PS2: The corresponding table for the small dataset I provided should look like:
2003 2004 2005 2006
2003 6 3 2 0
2004 3 6 3 2
2005 2 3 7 1
2006 0 2 1 5
That's it! Many thanks!
Quick followup question, which function should I use to give me the corresponding percentages (over the total number of records)?
Again, thank you for your time.
The % of total would be yet another table calculation but differently addressed:
the same could be done with a use of LoD I believe.
I can't have 0 displayed instead of blank cell where the value is null though....
common UIDs_9.3.twbx 14.6 KB