+ Reply to Thread
Results 1 to 6 of 6

How to move column in Piviot Table?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-14-2011
    Location
    Nepal
    MS-Off Ver
    Office 2021
    Posts
    117

    How to move column in Piviot Table?

    I have made a table with percentage in piviot table. But I can't move column in piviot table. How can I move column? Please find sample file. Your suggestion is highly appreciated.

    Indra Rai
    Attached Files Attached Files
    Last edited by Indra Rai; 08-28-2013 at 08:45 AM.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to move column in Piviot Table?

    Please see attached
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    09-14-2011
    Location
    Nepal
    MS-Off Ver
    Office 2021
    Posts
    117

    Re: How to move column in Piviot Table?

    Dear Alkey,

    Thank you very much for you prompt action. But I want to know how can I do this. Could you tell me step wise process?

    Indra

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to move column in Piviot Table?

    All you have to do is to click on the field where it says "Male" and then you have to re-sort it by selecting from Z to A. Unfortunately, I do not have Excel 2003 version to walk you through step by step.

    Please don't forget to thank those who helped by clicking on Add Reputation * and to mark threads as "Solved".

  5. #5
    Forum Contributor
    Join Date
    09-14-2011
    Location
    Nepal
    MS-Off Ver
    Office 2021
    Posts
    117

    Re: How to move column in Piviot Table?

    Thank you so much for you kind cooperation.

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to move column in Piviot Table?

    You're very welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA: Piviot table Month auto select based on current month?
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2013, 08:45 AM
  2. VBA: Piviot table Month auto select based on current month?
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2013, 07:18 AM
  3. piviot table
    By hshayh0rn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-04-2006, 10:00 AM
  4. [SOLVED] Piviot table help
    By JOn K via OfficeKB.com in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 01:05 PM
  5. Pivot table: order, move to column
    By excelhappy in forum Excel General
    Replies: 0
    Last Post: 05-09-2005, 02:31 PM

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