Hi Everyone, hope I can get help from this problem:
Name Month Price
One 01 10.00
One 02 11.00
Two 01 13.00
Two 02 14.00
I've tried a couple of transpose and cross tab rule but I can't get the result that I want.
Name 01 02
One 10.00 11.00
Two 13.00 14.00
Solved! Go to Solution.
Thank you @JoshKushner this gave me a lot of idea.
A follow up question, I added a new field called count
Name Month Count Price
One 1 2 10.00
One 2 4 11.00
Two 1 3 13.00
Two 2 6 14.00
And I want it to be this output:
Name Count 1 Count 2
One 2 10.00 11.00 4
Two 3 13.00 14.00 6
Through your sample, I got it right but I want to know if my logic for building the solution is correct.
I want to know if this is the simplest way to do my desire output. Thank you again.
Thank you very much! This solution saved me a lot! :)