Results 1 to 5 of 5

Item wise top ten and top hundred total in excel 2007

Threaded View

  1. #5
    Registered User
    Join Date
    08-16-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Item wise top ten and top hundred total in excel 2007

    Dear Friends

    i revised the output sheet please look it at again if that possible through pivot table or sumif function

    in the output sheet column are Gross Arrear Current Amount Net Amount

    Gross Arrear is ARGROSS

    Current amount is (NETAMT-ARGROSS)

    Net Amount is NETAMT

    Now in top ten defualter mean sum of top 10 argross of tarrif category. Like this other category top 10 and top 100 if possible and this data fetch from oracle database.



    Thanks
    Manoj
    Attached Files Attached Files
    Last edited by tanmanoj; 07-24-2013 at 11:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Total line item sale qty to be sum in a cell as date wise
    By geromio in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-15-2013, 10:50 PM
  2. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  3. Delete row wise duplicates & colomun wise simultaneously excel
    By Dipankar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 09:05 AM
  4. Item wise balance in Pivot Table
    By Samad in forum Excel General
    Replies: 3
    Last Post: 01-10-2005, 03:06 PM
  5. Item wise balance in Pivot Table
    By Samad in forum Excel General
    Replies: 0
    Last Post: 01-08-2005, 08:08 AM

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