Forum Discussion
Grouping data in different columns
I have a set of data which looks like the below: Order Number Amount 1 Amount 2 Amount 3 Amount 4 1 138 null null null 1 null 124 null null 2 null null 127 null 2 ...
Anonymous , Check all these four column should be of number type -Amount 1 Amount 2 Amount 3 Amount 4
Ande set their default summarization as the sum
What is the setting on your Order number column?
I have it as sum currently.