Cumulative until the begining of the year and monthly values in cross tab

[mohanri]

I have a requirement to print inception to date actual cost till beginning of this year and then monthly budget and actual values using crosstab. the report should look like this.


activity values till 2016 jan -2016 feb 2016 march 2016
1000
budget $25000 $2000 $2500 $3000
Actual $30000 $3000 $2750 $3500


I know how to get the monthly values. I need help in combing the values till the beginning of the year and the other values in a single row of the cross tab.

[MFGF]

I have a requirement to print inception to date actual cost till beginning of this year and then monthly budget and actual values using crosstab. the report should look like this.


activity values till 2016 jan -2016 feb 2016 march 2016
1000
budget $25000 $2000 $2500 $3000
Actual $30000 $3000 $2750 $3500


I know how to get the monthly values. I need help in combing the values till the beginning of the year and the other values in a single row of the cross tab.

Hi,

What sort of package are you using - relational or dimensional?

MF.