Pivot Pi vot Tab Table le Ana Anato tom my Report Filter area – optional area allowing filter of data items Row area – headings that go down the left sideĬolumn area – heading across the top of the table, ideal for showing trends over time Pivot Pi vot Tab Table le Ana Anato tom my Values area – data fields you want to calculate Usin Us ingg Pi Pivot vot Tabl ables es Rules: Īllow you to quickly see numerical relationships Often created from transactional data or raw data (like UD Financials).Work with large amounts of transactional dataįind relationships and groupings within dataįind a list of unique values for one field in dataĬreate subtotals that frequently include new additions Organize your data into a format that’s that’s easy to chart * Bill Jelen, Mike Alexander. Usin Us ingg Pi Pivot vot Tabl ables es Use a pivot table if you need to: Usingg Pivot Table Usin abless in Exce Excell 2007Ĭreate a pivot table.
