Skip to Content
0
Former Member
Dec 02, 2011 at 08:40 PM

Summary data in Crosstabs.

24 Views

Hi ,

I'm working on a report which has 4 tabs within it , the first one being detail and the rest 3 crosstabs. The crosstabs represent the summarised data of teh detail table which is grouped n summed up based on field say A1 , A2 , A3 and so on.

I want to dispaly at the end of the corsstab a single row which will hold the Total sum of all the data shown in the crosstabs. say "A" which is A=A1A2A3 .

I tried using the formula sum(field1) ForAlll 'Afield' but it repeated below every row of A1 , A2 , A3 ..

Rows : A1 , A2 , A3

Coulmns : field 1 , field 2 ..

Total : Sum (Field1) for all A's.

Please help me with the formula.