on 01-18-2016 6:29 PM
In crosstab crystal report 2008, i want to set a sum of the field as column header but unable to sum that field.
Hi, Try this.
1) Right click on crossTab
2) Select Crosstab Expert --> CustomizeStyle Tab
3) From Grid Options --> Check/ select Column Totals on Top
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Asif,
Here's what you need to do:
1) Note down the field you've used as first Column of the Crosstab
2) Go to the Group Expert > Insert a group on this field
3) Suppress the Group Header and Group Footer
4) Create a formula that looks something like this: (You'd need to replace the fields I've used with your database fields)
Sum({Finished_goods_qty}, {Field_used_as_the_first_column})
5) Go to the Crosstab Expert > REPLACE the existing second field under 'Columns' with the formula field you created above.
6) Go to the Crosstab Expert again > Customize Style tab > Under 'Columns', highlight the field below the the text 'Grand Total'.
7) Under 'Group Options', select 'Suppress Subtotal'
Hope this helps.
-Abhilash
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.