Calculations Between Cross Tab Totals

[cjsasaki]

Hi

I have made a crosstab and I want to know how to make a calculation between 2 Totals (2 different levels).

I have something like this :

                  Ciclo 1   Ciclo2
Total                     152   128
Ejecutado   Total          108   64
   Blocked            39   
   Error                    31   1
   Inprogress      1
   Passed           38   62
No Ejecutado   Total    44   64
                       44   64

I want to calculate "Total 152/Ejecutado Total 108"

[cjsasaki]

Hi

I have a Cross Tab that looks like this :
                  |  Date1 |    Date2  |
-------------------------------------------------------------
Planned     |     4      |    5         |
-------------------------------------------------------------
Executed   |     3      |    5         |
-------------------------------------------------------------
%             |     75%  |    100%   |
-------------------------------------------------------------
Passed      |     2      |    4         |
-------------------------------------------------------------
Fail            |      |      |     1        |


How can I do a calculation like :  Executed/Planned  and Executed/Planned .

Can this be done?

[BigChris]

Could try putting in a footer and unlocking the report, then add into the footer something along the lines of:

total([Executed] for [Date]) / total(Planned] for [Date])

[BigChris]

total([Name] for [Category]) / total ([Name])

[MFGF]

There appeared to be two virtually identical posts asking the same question here, so I have merged them into a single thread. Please do not double-post questions.

MF.