+ Reply to Thread
Results 1 to 6 of 6

Pivot Table won't work

  1. #1
    Registered User
    Join Date
    11-16-2018
    Location
    United Kingdom
    MS-Off Ver
    2019
    Posts
    35

    Pivot Table won't work

    Hi all,
    I'm trying to create a timesheet that will allow me to create a pivot table to see graphs on tasks, day and hours.

    Here is the link to the example https://docs.google.com/spreadsheets...it?usp=sharing

    But whenever I try to create a table for Tasks, and try to get the values for Tasks, it always come up with zero. Not sure what I'm doing wrong or if I should reformat the columns and rows to a different way so Pivot tables can read it.

    Any help would be great

    Thanks

    Sam

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Pivot Table won't work

    Hi Sam,

    It sounds you are trying to get a Sum for a bunch of TEXT. Check your data and see if the pivot is trying to add those strings up. Text cells have a value of zero. If that isn't close to the correct answer then supply a sample workbook so we can see what you are trying to do.
    Last edited by MarvinP; 09-07-2021 at 12:32 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-16-2018
    Location
    United Kingdom
    MS-Off Ver
    2019
    Posts
    35

    Re: Pivot Table won't work

    Thanks for this, I've included a link above?

    it is here too https://docs.google.com/spreadsheets...it?usp=sharing

    Thanks

    Sam

  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,149

    Re: Pivot Table won't work

    Do you need something like in picture-1 or picture-2 ?
    Attached Images Attached Images
    Last edited by Haluk; 09-07-2021 at 01:30 PM.

  5. #5
    Registered User
    Join Date
    11-16-2018
    Location
    United Kingdom
    MS-Off Ver
    2019
    Posts
    35

    Re: Pivot Table won't work

    Quote Originally Posted by Haluk View Post
    Do you need something like in picture-1 or picture-2 ?
    it would be picture 2 where it is the sum of all of Task 1 and all of Task 2

    How do you do that?

    Thanks

    Sam

  6. #6
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,149

    Re: Pivot Table won't work

    Sam,

    I used a custom calculated field for the Pivot Table in picture-2 where a simple formula is used to calculate the sums, which is;

    Please Login or Register  to view this content.
    The link to the Sheet is given below;

    https://docs.google.com/spreadsheets...it?usp=sharing

    You can make a copy of the sheet in your drive via "File >> Make a copy" menu.

    The animation, describing the steps is given in the link below;

    https://s9.gifyu.com/images/Test_HD2.gif
    Last edited by Haluk; 09-08-2021 at 08:34 AM.

+ 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. Cannot get pivot table to work at all
    By Tuff Training in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-03-2019, 04:49 AM
  2. Can pivot table and data table work together?
    By oscarchow1990 in forum Excel General
    Replies: 3
    Last Post: 03-28-2017, 10:33 AM
  3. Making a pivot table work with rest of a table
    By Excelfail in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-31-2015, 10:47 PM
  4. How to let Hyperlink work in pivot table?
    By freeSky in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-05-2012, 12:14 AM
  5. Pivot table macro does not work
    By ben2010 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-01-2010, 07:06 PM
  6. to make a pivot table to work with an adjoining table
    By byronova in forum Excel General
    Replies: 2
    Last Post: 09-06-2009, 10:47 AM
  7. allowing pivot table to work
    By RANDY IN NC in forum Excel General
    Replies: 3
    Last Post: 06-19-2007, 05:53 PM

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