Hi guys,
Have been struggling with this Cross-Tab issue. I've set up a Report so users can select the Start and End Month, and display the value of certain investments for each Month End. My boss now wants to see the Percentage Change from the first month's value to the last months value for each investment. E.g. if Investment 1 was worth $10,000 in July but worth $10,500 in October, display 1.05%.
I've played around with including the Total column (for Rows) and trying to get that to get the first number using the Maximum Date conditionally(Value at the final date: "sum({Value},maximum({ValueDate}))", etc) minus the second value (using the first date) but using this, declaring the date in a formula and calling that, etc, only give me various errors.
Does anyone know what I'm doing wrong there or how else to do this? There'll be a variable number of dates across the page and a variable number of Investment down the page, so I need to include this within the Cross-Tab somehow but I can't see how it can be done.