Devexpress xtrareport pivot grid grand total for the percentage column

Question

I have 3 columns like target, sales, percentage (sales/target *100). When i have shown these three columns in the devexperss xtrareport pivot grid the grand total percentage is just taking the sum of the columns. i want to show the percentage of the sum of sales / sum of target in both row and column grand total. Check the attached excel sheet

Answer 1

I achieved this with the following steps.

1. Create a new unbounded column
2. Set the Summary type as "Custom"
3. Set the Unbound Expression formula as "Sales/Target*100"
4. Set the Unbound Expression Mode as "Use Summary Value"
5. Set the Unbound Type as Decimal
6. Add that new column into the data area.