Results 1 to 2 of 2

Pivot Table with Ordinal Values and percentage difference

Threaded View

algebr Pivot Table with Ordinal... 01-20-2013, 09:04 PM
VKS Re: Pivot Table with Ordinal... 01-21-2013, 01:09 AM
  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    NY, USA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Pivot Table with Ordinal Values and percentage difference

    Hello,

    I have two columns of data. Both columns contain ordinal data, that is strings which have increasing levels of desirability, like good, better, best, bestest.

    I want to have a pivot table that will show the % increase of say good in the first column to better in the second column.

    any ideas as to how to do this?

    thank you.

    EDIT, I am now just assigning an integer to the ordinal data.
    Last edited by algebr; 01-20-2013 at 09:39 PM.

Thread Information

Users Browsing this Thread

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

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