Manual crosstab

[aftab45]

Hello,

I'm in the process of creating a manual crosstab. One of my columns is derived from subtracting one of the other columns from another column:

Column 1 Column 2 Column 3
Person A 10 1 9
Person B 20 2 18
Person C 30 3 27
TOTAL 40 6

Columns 1 & 2 use summary functions (column 1 is a count and column 2 is a sum). Column 3 is a formula which says:

Count(Column 1) - Sum(Column 2)

This works fine. But if I want to do a grand total for column 3 I get:

'This field cannot be summarised'

Do I need to use a different approach for column 3?

Thank you in advance.

 

[TheBlondOne]

Hi there,

Have you tried creating a seperate formula i.e GT1, and then subtracting the 2 grand total fields from each other i.e

GT1(40) - GT2(6)

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[aftab45]

Hello,

Thank you for your help. Thats worked a treat!

 

[TheBlondOne]

np

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )