Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Select a column from a worksheet and write in a constant from that column. Next, select the value column for which to compare the constant from the original column. The column being selected isn''t allowed to contain different values for the key constant. If there are different values for a key constant, an error results. 

...

This is an aggregate function.

Example

Original Data:

Department

Year

Dollar

Department 1201010
Department 1201020
Department 1201110

Department 2

201110
Department 2201210
Department 1201330
Department 1201330
Department 2201335

Create a new worksheet:

Code Block
GROUPBY(#RawData!Department)
GROUPSELECT(#RawData!Year;2010;#RawData!Dollar)
GROUPSELECT(#RawData!Year;2011;#RawData!Dollar)
GROUPSELECT(#RawData!Year;2012;#RawData!Dollar)
GROUPSELECT(#RawData!Year;2013;#RawData!Dollar)
DepartmentDollar_in_2010Dollar_in_2011Dollar_in_2012Dollar_in_2013
Department 1<error>10<empty>30
Department 2
101035