• Replies 7 replies
  • Subscribers 962 subscribers
  • Views 162 views
  • Users 0 members are here
Related

Rearranging Columns in Pivot Tables

Brian Barry (Past Member)
$organization

Hi All!

*Updating this to avoid the confusion*

Just a simple question, but does anyone know how (if you can at all) to rearrange the column order in a pivot table? In the photo below i'd like to have "Gold Circle" be listed first. These all come from the same field, so rearranging the fields doesnt apply in this instance.

Best,

Brian

  • $organization
    In your data/values window to the left where you add your values/rows to the widget, simply stack them in the order you want them to appear left to right by dragging and dropping them above/below each other. Just click and hold, then hover above or below and release. It will indicate where it will fall during the hovering process.
     
    Best,
    Michael
     
     
    Michael Naess
    Senior Manager, Inventory and Pricing
    Dallas Symphony Orchestra
    Morton H. Meyerson Symphony Center
    Schlegel Administrative Suites
    2301 Flora Street
    Dallas, Texas 75201-2413

    214-871-4075 - phone
    214-871-4049 - fax

    M.Naess@dalsym.com
    www.MyDSO.com

    https://d15gc4eof6ew0j.cloudfront.net/img/marketing/2019-20%20Season%20Graphics/Subscription%20Images/DSO2019_Web_185x74.jpg
  • $organization
    Hi Brian,
     
    You can rearrange any of your criteria on a pivot table by dragging and dropping it to where you want to move it. You can even move from columns to rows until you get the information to appear like you want.
     
    I hope this tip makes sense because it’s a little hard to explain. I’ve found this to be a little finicky – you’ll try to move it and it’ll snap back to its original place. I’ve found that placing the criteria at the bottom of the list and then moving up works well. A gray box will also appear before you drop the criteria. Screenshot included.
     
     
     
     
    Nicole Wetzell
    Director of Audience Development
     
    50 E Ida B Wells Dr | Roosevelt University | Chicago IL 60605-1214
    Phone Number: 312.341.2356 | Ticket Services Center: 312.341.2300
    Fax Number: 312.341.2360
    Give today to support the Auditorium Theatre
     
  • $organization

    Hi Brian,


    In the widget update, on the left side you can rearrange the order within rows or values or columns sections (click and drag) but I haven't found a way to move the value to the front of the rows section.


    Sally


    Sally Slocum | Director of Ticketing & Analytics

    Broadway Sacramento | Broadway at Music Circus & Broadway On Tour

    1419 H Street, Sacramento, CA 95814 | P: 916-557-2774 | F: 916-557-2775  | broadwaysacramento.com

    Formerly California Musical Theatre



  • $organization

    Michael and Nicole are right when it comes to dealing with Values or anything on the left pane. I had a similar issue as you, however, where I was dealing with Seasons. I ended up renaming the Seasons because it appears that they just appear alphabetically. Not the best solution, but I was dealing with Gallery admission changing to Admission, to get it to the front so it wasn't a big deal. 

  • $organization in reply to Nicole Wetzell

    Ahh, sorry i should have specified. The column headers (A Price, B Price, C Price, D Price and Gold Circle) are all coming from the same Field. So is there a way to rearrange their order if they come from the same field? 

  • $organization in reply to Brian Barry (Past Member)

    Hi Brian, 

    Have you tried adding Zone Rank?

    Zone group Rank might be better in your example

  • $organization in reply to Heath Wilder

    Thanks, Heath! That's a nice little hack to get it the way I need.