Hi,
Im developing a report which will show data for YTD, YTD-1 and YTD-2 that is if the prompted months is May 2015 then
YTD will show an aggreagte of Jan to May 2015
YTD-1 will show an aggreagte of Jan to April 2015
YTD will show an aggreagte of Jan to March 2015
I have successfully done this. But the requirement is i want to display Crosstab Column Header as
May 2015 for YTD calculated value
April 2015 for YTD-1 calculated value
March 2015 for YTD-2 calculated value
This display of month name as header should not affect the column values.
Im sure we can do this using Caption function without affecting the Column Values. But not getting the complete function could you please help me.
Thanks