Focal Point
Sub-total

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4641068331

May 31, 2005, 01:24 PM
thangam
Sub-total
Can we consider only selective records when we sub-total command?

For eg,
Suppose, if we have 5 rows, out of which 3 rows need to be considered for subtotal.
May 31, 2005, 04:12 PM
reFOCUSing
Is there a way you can tell which record should be in the sub-total? Is there some type of indicator? Can you COMPUTE or DEFINE one?
June 01, 2005, 04:05 AM
thangam
Col1 Col2 Count
A V1 3
V2 2
V3 5
Total A 10
B V1 4
V2 3
V3 1
Total B 8

That was the output when we apply subtotal on Col1.V3 Should be ignored at the time of calculating subtotal. But it needs to be displayed in the report.

The expected output is
Col1 Col2 Count
A V1 3
V2 2
V3 5
Total A 5
B V1 4
V2 3
V3 1
Total B 7


Please guide us.
June 02, 2005, 03:51 AM
susannah
use RECAP function instead of SUBTOTAL; look it up. you can specify the formula and take the sum of , say, each of the values multiplied by some noprinted defined field of 1 and 0; 0 for the records you don't want summed, 1 for the records you do.