Logo: Wesleyan University
  • Tools
    • WesPortal
    • Directory
    • Library
    • OneStop
    • WesConnect
    • Calendar
    • WesMaps
    • WFS
    • Moodle
    • EMS
    • GApps
  • About
  • Admission & Financial Aid
  • Academics
  • Campus
  • Athletics
  • Give
  • Students
  • Alumni
  • Parents

Student Faculty Information System

PeopleSoft Campus Solutions

Feed on
Posts
Comments

BIP – Pivot Table and Chart

BIP Template – Pivot Table and Chart

  • Pivot Table – A Pivot Table is a tool that allows you to reorganize and summarize selected columns and rows of data to obtain a desired report.
  • Chart – There currently are no chart demonstrations.

 

Pivot Table Illustration

This is a basic demonstration of how to set up a Pivot Table in a BI Publisher Word Template.

You may be familiar with pivot tables in Microsoft Excel.  For example, they can be useful for condensing information that you run from a PS Query.

Pivot Table is one of the options on the Insert menu in BI Publisher Word Template.

 

BIP template insert menu Pivot Table

As with Excel, the pivot table in the template allows you to reorganize and summarize selected columns and rows of data to obtain a desired report.  Among other functions, the pivot table can automatically sort, count, total or give the average of the data.  The results are displayed in the template in a table showing the summarized data.

 

The user sets up and changes the summary’s structure by dragging and dropping fields graphically. This “rotation” or pivoting of the summary table gives the concept its name.

BIP template pivot table dialog

Comments are closed.

Modified on: Jun 6th, 2016 Log in

  • Student Faculty Information System

    PEOPLESOFT CAMPUS SOLUTIONS
  • Updates

    • Wesleyan Functions List
    • Alliance 2019 Call for Proposals
    • Alliance 2019 Registration and Housing Rates are Now Available
    • NERUG 2018 Conference Advance Rate Available
    • HEUG Webinars in August
  • Documentation

    • >Welcome<
    • ***Security Request Form***
    • INTRODUCTION
      • * SFIS Access
      • * SFIS and Web Browsers
      • * SFIS FAQs
      • * SFIS QUICK LINKS/ LOGIN
      • * SFIS User Defaults
      • UPGRADE: New & Notable Features
        • – What’s New? –
        • Activity Guide
        • Common Attribute Framework
        • Milestones
        • Program Enrollment and Activity Management
        • Query and Reporting Features
        • Related Content
        • Work Centers
    • PROCEDURES
      • PROCEDURES – SFIS
        • Committees
        • DATA RETRIEVAL
          • BI PUBLISHER/ XMLP
            • BIP Templates
              • BIP – Fields, Tables and Forms
              • BIP – Formatting
              • BIP – Pivot Table and Chart
            • BIP Tutorials and Demonstrations
          • COMM GEN (Communication Generation)
          • POP SELECT
        • Duplicate Records and Search/Match
        • Error Messages, Troubleshooting, Tips, FAQs
        • External Organizations
          • SAT Codes – CEEB Codes – ATP Codes
        • Glossary – PS Campus Solutions
        • Service Indicators (Holds)
      • PROCEDURES ~ General
        • CS 9.0, PTools 8.54
        • CS 9.2, PTools 8.55
        • HEUG WEBSITE Features
        • HEUG: Alliance and Other Links
        • HEUG: BI Publisher
        • HEUG: Comm Gen
        • HEUG: Pop Select and Pop Update
        • Link – Upgrade Blog
        • Links List
        • Oracle/PS Documentation
    • QUERY
      • QUERY INSTRUCTION
        • PS Query Instruction – Overview
          • 1 – Basic Query Concepts and Query Viewer
          • 2 – Query Manager
          • 3 – Advanced Concepts
      • QUERY PRESENTATIONS/ DEMOS
        • Counts, Sums and Conditions – Criteria and Having Pages
        • Dates in Query
        • Effective Dates in Query
        • Expressions and Wesleyan Functions
        • Joins In Query
        • Prompts in Query
      • QUERY TOOLS AND REFERENCES
        • Annotated Visual Demo – Creating a Query
        • Connected Query and BI Publisher
        • Criteria Properties
        • Encyclopedia/ Glossary
        • Query – EXPRESSIONS / FUNCTIONS
        • Query – WESLEYAN FUNCTIONS
        • Query FAQs and Troubleshooting
        • Query Manager Pages
        • Query to Excel – Pivot Table
        • Query Viewer – View Results & Run to Excel
        • Searching and Records Commonly Used
        • Tip Sheet for Query
      • QUERY ~ EXTERNAL REFERENCES
        • Expression Syntax (SQL) – Outside Sources
        • Using Microsoft Excel and Word with PS Query
    • Links

      • HEUG Website
      • Oracle Error Messages
      • PeopleSoft Wiki
    • SFIS Blog Links

      • Blog List of Links
      • Oracle / PS Documentation
      • Query Wesleyan Functions
      • SFIS Access
      • SFIS List of Links
      • SFIS Query Instruction Course
    • Wesleyan Links

      • Academic Calendar
      • Campus Solutions (SFIS) Upgrades
      • Finance Monthly
      • ITS System Announcements
      • News @ Wesleyan
      • SFIS Blog Home Page
      • WES ITS Home Page
      • WesMaps
  • Archives

Student Faculty Information System © 2025 All Rights Reserved.


Wesleyan University

44 Wyllys Avenue
Middletown, CT 06451
60-111-1111

  • Contact Us
  • Copyright & Privacy

© 2014 Wesleyan University

Resources

  • Human Resouces
  • Library
  • ITS
  • Student Accounts
  • Residential Life
  • Career Center
  • Offices & Services

Find It

  • Employment
  • Directions
  • Give
  • Apply
  • Athletics
  • CFA
  • Events
  • Visit Wesleyan
  • WESU (radio)

Tools

  • Portfolio
  • Directory
  • Library
  • OneStop
  • Wesconnect
  • Calendar
  • WesMaps
  • WFS
  • Moodle
  • EMS
  • Gapps

Connect With Us

Facebook Twitter Flickr YouTube Tumblr Google Plus
iTunes U