+ Reply to Thread
Results 1 to 1 of 1

how to add a special subtotal in the pivot table?

  1. #1
    Registered User
    Join Date
    05-02-2006
    Posts
    1

    how to add a special subtotal in the pivot table?

    my excel look like this:

    part qty part2
    -----------------------------------------
    p1 10 fg1
    p1 10 fg2
    p2 5 fg3
    p2 5 fg4
    p2 5 fg5
    -----------------------------------------

    the pivot table looks like this:

    part qty part2
    ---------------
    p1 10 f1
    f2
    p2 5 f3
    f4
    f5
    ---------------------------------------------

    if i sum the instock_qty, it will look like this:

    partnumber instock_qty usedpartnumber total
    --------------------------------------------------
    p1 10 f1 10
    f2 10
    -------------------------------------------------
    p1 total 20
    -------------------------------------------------
    p2 5 f3 5
    f4 5
    f5 5
    ------------------------------------------------
    p2 total 15
    ------------------------------------------------

    But what i want is:

    partnumber instock_qty usedpartnumber
    ---------------------------------------------
    p1 10 f1
    f2
    ---------------------------------------------
    p1 total 10
    ---------------------------------------------
    p2 5 f3
    f4
    f5
    ---------------------------------------------
    p2 total 5
    ---------------------------------------------

    how can i do that? really appreciate your help!
    Last edited by MiaYang; 05-02-2006 at 11:13 AM.

+ Reply to Thread

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