Results 1 to 4 of 4

Need help about pivot table and pivot chart !!!

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2010
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    8

    Need help about pivot table and pivot chart !!!

    In my Excel file, sheet pivot.

    How can i show only the Duration and Amount Granted per year, i dont want to SUM those figures because of no meaning when sum those figures.

    Also i want to insert 1 new column "Total Amount Granted". This column's value is (Duration *Amount Granted per year). And i want to sum this column.

    Finally, how can i do the chart which show ONLY "Total Amount Granted" (not Duration and Amount Granted per year).

    I hope someone can tell me the way to do, because i need to understand the strategy.
    Thank you very much. I really need the answer
    Attached Files Attached Files
    Last edited by ptx1987; 03-31-2010 at 02:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1