+ Reply to Thread
Results 1 to 6 of 6

Extract amount from pivot table

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Extract amount from pivot table

    Hi friends

    I would like to know is there any formula to bifurcate amount from pivot table.



    Please refer attached workbook (Column "I") for further information.

    Regards
    Sagar
    Attached Files Attached Files
    Sagar
    Arise awake & stop not till d goal reached

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Extract amount from pivot table

    I am sure you are arriving the Column-B and Column-C data from pivot table Just show the source of that pivot for getting solution.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Extract amount from pivot table

    Hi,

    The source from Column "B" & Column "C"

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Extract amount from pivot table

    Please refer post #4 of this thread

    http://www.excelforum.com/excel-form...e-returns.html

  5. #5
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Extract amount from pivot table

    Thank you Sixthsense

    Reputation Added

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Extract amount from pivot table

    Glad it helps you and thanks for the feedback and rep

+ 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