Standard Reporting
Reference Manual
Sorting and Totalling
:
Subtotalling
: Showing only the First Occurrence of Values
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
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.