Oct 5, 2009

What can you do with the powerful Pivot Table?

  1. Iterate items in Pivot Field
  2. Using Filter in Pivot Table
  3. Calculated Fields
  4. Summarize data show as same row
  5. Sort
  6. Refresh Pivot Table
  7. Hidden a PivotItem
  8. Remove PageField
  9. Change exist SourceData
  10. Delete Pivot Table
  11. ShowPage
  12. Percent % of Row
  13. Difference From
  14. Running Total
  15. Summarize Date Fields with Grouping
  16. Adds the visible field names to a list on a new worksheet
  17. Add the page field names to a list on a new worksheet

No comments: