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 ######
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..
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By BozzA in forum Excel Programming / VBA / Macros
Last Post: 01-20-2014, 10:37 PM
By shshsh in forum Excel Charting & Pivots
Last Post: 12-09-2013, 12:41 PM
By tellmeaboutthemoon in forum Excel Charting & Pivots
Last Post: 09-27-2012, 08:49 PM
By loguie668 in forum Excel General
Last Post: 03-25-2011, 12:00 AM
By Janet BN in forum Excel General
Last Post: 06-26-2006, 10:25 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1