Is there a way to manually sort fields in a Pivot table?

2013-10-26  Source: Original Site  Category:Excel  Views:0 

Advertisement

I have some dates in the format mm/yyyy that are used in a pivot table.
The problem is the dates are 092005, 102005, 112005, 122005, 012006 & 022006.
Obviously when this goes in to the pivot table it gets sorted into order as a number so ends up like this:
012006, 022006, 092005, 102005, 112005, 122005
Is there a way of preventing this?

Related articles
  • Is there a way to manually sort fields in a Pivot table? 2013-10-26

    I have some dates in the format mm/yyyy that are used in a pivot table. The problem is the dates are 092005, 102005, 112005, 122005, 012006 & 022006. Obviously when this goes in to the pivot table it gets sorted into order as a number so ends up

  • Is there a way to compare two fields from two different tables? 2012-01-24

    I am working on a database that will help users to reserve rooms..I have a table DATA with ROOMNAME, START_DATE,END_DATE,START_TIME,END_TIME, USER_NAME as the fields. I have another table HISTORY that has a history of all the reservations. I would li

  • MySQL Is there any way to protect a field value? 2013-06-07

    This is my doubt I'm a newbie So please answer with an example, For example we cann't change our email id in some domains, They are using any special method for this?Is there any way to protect a field value? Advanced Thanks, Regards Seo Services | W

  • is there a way to filter xml fields in javascript? 2014-03-06

    is there a way to filter xml fields in javascript? I'm not displaying my xml using xsl, I'm using it to feed a dhtmltree javascript library. So what I need to do is edit the xml in javascript depending on some user interface input. For example, I hav

  • Oracle Is there any way to clean up some space in Temp Table Space 2014-07-03

    Hi Is there any way to clean up some space in Temp Table Space? If you have query or script then please give it to me.

  • Removing old field values from Pivot Table 2012-12-07

    How do you remove old field values from the Pivot Table drop downs for a field? Usually, I can do this by removing the field from the pivot table, refreshing and adding the field back in but it doesn't always work and can become time consuming. Examp

  • Oracle Is there any way to define the field to store specifically the password ?? 2012-02-29

    Is there any way to specify/define the field to store specifically the password in the Orale 10g., So that ., Instead of defining the field with varchar2 type., i want to define the field as if it signifies to store the password field., so that if us

  • Oracle Is there any way to show the fields with a specific value? 2013-07-18

    I have a clinical database which collects patients clinical information like fever, fatigue, weigh loss, and etc. the table is like this: id barcode fever fatigue weightloss..... 1 590001 positive negative positive ..... I wonder is there any way to

  • Ubuntu Is There Any Way To Manually Edit Replaygain Tags For Tracks and Albums? 2014-08-29

    I know there are tools for automatically calculating and tagging sound files with replaygain data for volume normalization. Is there any way to simpl edit and enter your own information for a given album or track? They don't always work great and I w

  • Oracle is there a way to manually order a LOV statement generated by SQL? 2014-12-30

    I have a table and I generated a LOV using SQL: select distinct fruits from food, which gets me a list of fruit names from the fruit column. Now when the user creates a new row i want a specific Fruit name to be the first choice like "Coconut"- regar

  • Oracle Is there any way to detect commited deleted record in a table? 2012-04-15

    Is there any way to find out commited deleted record in a table without using triggers?

  • Oracle Is there any way to avoid some columns data using external table? 2013-05-10

    I am using external table, to load data from files to oracle. For me, there is a requirement, the file is going to be added more columns frequently. So, I dont want to load those columns inorder to continue with the application, without interrupting

  • MySQL Is there a way to have all partitions in the same table file? 2013-08-24

    I'd like to use innodb_file_per_table for admin reasons, but our db is heavily partitioned and we're a suffering a severe performance hit (>40%) because of the large numbers of files involved. Is there a way to have all the partitions in the same

  • Problem with page fields in excel pivot table 2015-05-03

    I'm encountering a very strange bug with the page fields on some excel 2002 pivot tables. Say there are 10 page fields on a spreadsheet. If I try to pull down the 8th field, for example, actually the data for the 9th page field shows up. The 8th fiel

  • Calculated Fields With Excel Pivot Tables 2012-11-08

    I have recently created an an excel report based on an Olap Cube and I now have all of my data organized into a pivot table in excel. My only problem now is that I want to perform calculations on two of my measures columns and create a new calculated

  • Ubuntu Is there a non-OOo based spreadsheet app that supports pivot tables? 2013-01-24

    If OO, or any other OO-based office spreadsheet program crashes on me again I think my head is going to explode. I've tried OOo 3.2, Lotus Symphony 3.0 FP1, Gnumeric 1.10.8, Wine with Excel 2007 and everything but Gnumeric is more buggy than a picnic

  • Oracle Is there a way to expand form fields dynamically ? 2013-08-11

    I have a tabular form with one column that can contain long text and sometimes it makes it difficult to read. I want to create the form so that when the text contained of the field is too large I have a way to expand (at runtime) the field so I can e

  • Ubuntu Is there a way to add extra fields to the Hamster Applet? 2014-07-24

    I'd like to be able to extend the hamster applet functionality to include some extra fields if possible. Here's my scenario. I use hamster to track time spent on clients. I generally use the Category for the client name and the Name for the Project.

  • Ubuntu Is there a way to manually install GParted? 2012-11-22

    I have a Ubuntu system where the internet has been whitelisted so that I can't use Synaptic. I was wondering if there was a way to install GParted without Synaptic? Do something with the ISO file perhaps? Or would this turn out to be quite complicate

  • Is there a way to make a field in a table a variable? 2013-11-21

    I'm trying to do a SELECT links FROM mytable and use the field links as a variable. What I want is to be able to select links and add <?php echo 'links'; ?> outside of the main php and incorporated into the main html. It'll look something like