Do Not Aggregate
Returns the value of a single row, otherwise null.
This method can be used to display a source table.
Below is a source table showing two fields Number and Arbitrary, with Aggregation set to DoNotAggregate and grouped by the Row field. This means Row is also the Breakdown field.
|
Row |
Number |
Arbitrary |
|
A |
1 |
3 |
|
B |
2 |
2 |
|
C |
3 |
1 |
|
D |
4 |
0 |
|
E |
5 |
-1 |
|
F |
6 |
-2 |
|
G |
7 |
-3 |
|
H |
8 |
0 |
|
I |
9 |
0 |
|
J |
10 |
0 |
Sample table
If there are multiple items or rows without any grouping, then the value of the method is just n/a.


