After reading a lot of tips from this community, there are just a few things which I can't figure out.
I'm currently struggling with the following:
CrossTable (Year, Budget, 2)
(biff, embedded labels, header is 1 lines, table is Sheet1$);
I would like to split the Budget of every EmployeeID in months per year (for example: EmployeeID 2 has 2.000 in 2004, which means 166,67 per month). I've also loaded a Master Calendar, it would be awesome if I could fit this with my Master Calendar to eventually compare Order from EmployeeID with Budget from EmployeeID.
What is my next step? Thanks in advance for your help!