SAP Crystal Report - Formula in Cross Tab Report

[Former Member]

I have a below requirement in a cross tab report,

Category Name Valu1 Value2 %ge

-

---

A Car 40 50 80

A Bike 30 60 50

Total 70 110 63.6

%ge is a formula field and is calculated as value1/value2 * 100

Consider the Total section as a group footer.

In the cross tab report how do I put the formula field for %ge in Total section.

[abhilash_kumar · Accepted solution]

Hi,

In the snapshot, isn't the 'Total' row showing the right percentage? (70/110 * 100 = 63.6 )

How do you want it to be calculated?

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I want to put the formula for Total in Group Footer. How do I put the formula in Group Footer in CrossTab report for such kind of calculations (%ge) ?

[Former Member · Accepted solution]

Vishujain

Crosstabs are very structured and you are limited in what you can do with them. You can do a percentage summary in Crosstabs, but only as a percentage of the row total or the percentage of the column total. You cannot put a formula in the crosstab to do a percentage of a values in seperate rows. Any time I need to perform a function not available in a crosstab, I do a manual cross tab. Look at: [Manual Crosstab Explaination|]

Debi

Edited by: Debi Herbert on Nov 3, 2011 11:51 AM

[Former Member]

You can not put a formula in the total row - crosstabs summerize.... Any field you put in the crosstab will be summarized in the total row, and only fields in the rows can be summerized.