Showing only the First Occurrence of Values

For a sorted column, you can output only the first occurrence of a value. For example, set the Values to 1st for the HBORE column:

Centre Line Length Report for /100-B-1 /100-B-2

PIPE NAME PSPEC HEAD BORE CENTRE LINE

LENGTH

/100-B-2 /100-B-2-B1 /A3B 100.00 7610.35

-----------

7610.35

/100-B-1 /100-B-1-B2 /A3B 80.00 2455.19

/100-B-2 /100-B-2-B2 /A3B 2526.65

-----------

4981.84

/100-B-1 /100-B-1-B1 /A3B 50.00 39524.56

/100-B-1 /100-B-1-B3 /A3B 3119.80

-----------

42644.36

===========

55236.56

You can display each value for a sorted column next to the corresponding subtotal value.

Set the Values option for HBORE (which must be sorted) to Sub. Set the Centre Line Length Subtotals to 4, that is, show subtotals for each value in column 4 (HBORE).

Centre Line Length Report for /100-B-1 /100-B-2

PIPE NAME PSPEC HEAD BORE CENTRE LINE

LENGTH

/100-B-2 /100-B-2-B1 /A3B 7610.35

-----------

100.00 7610.35

/100-B-1 /100-B-1-B2 /A3B 2455.19

/100-B-2 /100-B-2-B2 /A3B 2526.65

-----------

80.00 4981.84

/100-B-1 /100-B-1-B1 /A3B 39524.56

/100-B-1 /100-B-1-B3 /A3B 3119.80

-----------

50.00 42644.36

===========

55236.56