If you are unable to create a new account, please email support@bspsoftware.com

 

Caption function:Cross tab header as YTD, YTD-1, YTD-2 starting months

Started by imeu, 01 Sep 2015 01:40:17 AM

Previous topic - Next topic

imeu

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