Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

pivot table summaries data that is sourced from another table. Using pivot tables, you can calculate aggregating functions, such as sums, maximums, and averages for one or more columns of data. Optionally, these sums can be performed across groups of values from one column and broken out in columns based on the values in another. In

D s product
rtrue
, a pivot table is composed of the following basic elements:

...

D trans
p03ValueSUMIF(POS_Sales, Store_Nbr<4)
Typestep
p01NameColumn labelsp01ValueStore_Nbr
p02NameRow labels
p02ValuePRODUCT_DESC
p03NameValues
p04Value500
p04NameMax number of columns to create
SearchTermPivot table

...