+ Reply to Thread
Results 1 to 7 of 7

Pivot table slab wise

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    veraval
    Posts
    39

    Pivot table slab wise

    Dear sir,

    i have raw data from our system generated software where order value displays from 0.00 to lacs and crore i need the data buyer code wise that how many PO created from particular buyer for a particular slab range.
    my slabe range is different
    i need data for 0-1000, 1001-2500, 2501-5000, 5001-10000, 10001-25000, 25001-50000, 50001-100000, 100001-200000, 200001-3lac, 3 lac-3.5lac, 3.5lac - 5lac and 5lac - above



    regds
    devesh

  2. #2
    Registered User
    Join Date
    09-23-2008
    Location
    veraval
    Posts
    39

    Re: Pivot table slab wise

    I m attaching a file for your reference
    one sheet has raw data where slab range displays my requirement
    in pivot table can we give custom grouping for different slab like i mentioned in my question (first thread)

    i m using office 2007

    regds
    devesh
    Attached Files Attached Files
    Last edited by devesh.agrawal; 04-10-2009 at 11:50 PM.

  3. #3
    Registered User
    Join Date
    09-23-2008
    Location
    veraval
    Posts
    39

    Re: Pivot table slab wise

    pls reply if you have solutions... it requires on urgent basis.
    Last edited by devesh.agrawal; 04-13-2009 at 01:13 AM.

  4. #4
    Registered User
    Join Date
    09-23-2008
    Location
    veraval
    Posts
    39

    Re: Pivot table slab wise

    pls help me

  5. #5
    Registered User
    Join Date
    07-22-2008
    Location
    DELHI
    Posts
    11

    Smile Re: Pivot table slab wise

    Hi Devesh,
    your question is not very difficult to do,but i am facing a little difficulty to understand it,kindly tell me if (0-1000) describes the coumt value of 501 and next column shows the sum under this category.

  6. #6
    Registered User
    Join Date
    09-23-2008
    Location
    veraval
    Posts
    39

    Re: Pivot table slab wise

    thnx for your help

    0-1000 is total no of purchase order between 0-1000 rupees made by particular buyer(501) it is not sum it is totay qty
    i need different slab for PO like between 0-1000 ruppes, 1001-2500 rs, 2501-5000, 5001-10000, 10001-25000 and so on..

    next column shows the total value of 0-1000 suppose between 0-1000 200 PO made by 501 buyer the 200 POs value iis 250000.00 like this

  7. #7
    Registered User
    Join Date
    09-23-2008
    Location
    veraval
    Posts
    39

    Re: Pivot table slab wise

    Hi experts

    pls help me on this issue

    waiting for your reply

+ 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