+ Reply to Thread
Results 1 to 2 of 2

Group field disabled

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Paris
    MS-Off Ver
    Excel 2010
    Posts
    2

    Group field disabled

    LUTissue.PNG

    Hello,

    I am starting with look-up table and I am facing what seems to be a recurrent issue:

    I have in a column of my LUT hours and I would like to group those hours.
    Note that I've already browsed forums (the format of the data is hours both in sources and in the pivot table, there is no blank within the data).

    Thanks if you have any idea on what could be the error.

  2. #2
    Registered User
    Join Date
    04-12-2012
    Location
    Paris
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Group field disabled

    OK I found the issue..
    Even when changing the cell format of my data to hours, it wasn't effective : Data was still considered as text.
    To change it I had to select the column and click on Text-to-Column. Then I was able to group my data per hour.

    I hope this could help someone in the future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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