How to insert a customized calculated member in a crosstab r

building reports crystal reports
1

Hi All,

I have a cross tab report that lists the Activities in Columns and Employee Names in the Rows and displays the Sum of Quantities in the values.

I need to insert a new column in front of each activity so that the values in this column will be the Sum of Quantities/2

Is this possible to be achieved in crystal reports?

My new crosstab will look like the one attached to this message.

Any response is highly appreciated.

Thanks.
crosstab_example.JPG

sapwebintelligence (BOB member since 2016-07-27)

2

Please create a formula and use it in CrossTab… Hope this should work as expected…

surya.g :india: (BOB member since 2009-11-24)

3

Thanks Surya,

Yes I had to create a custom formula to do this.

sapwebintelligence (BOB member since 2016-07-27)