+ Reply to Thread
Results 1 to 2 of 2

Pivot Data Sorting

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2016

    Pivot Data Sorting

    When you create a simple pivot table having for instance, Country, ID number, Date of issue and Cost.

    The pivot is created with country and cost; when i double click on the cost for a specific country, the data is create in a new sheet. HOWEVER, the data is not sorted by the date. How can I amend this?

    Other issues include coloumn widths which are sometimes small and therefore not showing the data; just ######


  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365

    Re: Pivot Data Sorting


    I feel if you have your data sorted before hand, before double clicking, the new sheets should have sorted data..

    Regarding Column Width, On the Pivot Right Click > Pivot Table Options > Layout & Format > Autofit Column Width On Update

    This should help..
    Deep Dave

+ 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. Sorting Data for use by Pivot Table
    By BozzA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2014, 10:37 PM
  2. Data Sorting/Pivot Table
    By shshsh in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-09-2013, 12:41 PM
  3. Sorting data for use in a pivot chart. Can anyone help?
    By tellmeaboutthemoon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-27-2012, 08:49 PM
  4. Pivot table and sorting data
    By loguie668 in forum Excel General
    Replies: 1
    Last Post: 03-25-2011, 12:00 AM
  5. [SOLVED] Sorting Data in a Pivot Table
    By Janet BN in forum Excel General
    Replies: 5
    Last Post: 06-26-2006, 10:25 PM


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