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.