Crystal Report Cross Tab Custom Total

Question

Scenario is,

I want to make cross tab crystal report like below image

I made cross tab report shown below but it showing obtain marks total only, I want proper percentage at end ((ObtainMarks/TotalMarks)*100) help me to sort out pls. im new to corss tab. Its my 4th day on seraching about this topic

Answer 1

I have resolved my Issue on SCN Forum at http://scn.sap.com/thread/3871853

.@Siva's Answer is start point to solution

Answer 2

@Siva this is my Preview Tab for Report, It showing empty Cross tab options. Dataset for this report is made in Visual studio. I Select that Dataset as ADO.NET(XML)

Answer 3

You need to use calculated member to achieve this.

Go to preview on last column right click --> calculated member --> insert

You will get a new column added and in that edit the formula for the column and write your formula