LinkBack URL
About LinkBacks
I have created a pivot chart to show the number of judicial dispositions for each type of dispositions. When I check my numbers in each type, they are one more than then should be. I don't understand why.
I have created a pivot chart to show the number of judicial dispositions for each type of dispositions. When I check my numbers in each type, they are one more than then should be. I don't understand why.
Can you post the workbook, assuming it is desensitized?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Please see the attached file.
Can you point to exactly which values, on specific worksheets, are wrong?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
It is the Grand Totals on the Final Outcome 08-09 worksheet. They are all one more than they should be.
huh, I'm not seeing that.
First row on that table reads: 11 , 1, and 6 which add up to 18. When I count the dates in the H column of your 'Disp by Case' worksheet - I also get 18.
Nothing looks wrong to me
But if you count the dispositions in the first worksheet, the amounts are not right. That pivot chart was created from the first worksheet. So, I guess the totals on that chart, not just the Grand Total are not correct. Sorry, I should have clarified that.
Hello,
check your data. Some cells that appear empty actually contain a space. These will be included in a count.
cell H3 on the data sheet has a space. That accounts for the wrong count of 11 instead of 10.
cell J262 contains a space
cell L213 contains a space
By the way, there is not a single pivot chart in the whole workbook. What we're looking at are pivot tables. Details matter. Naming things correctly helps us help you.
cheers, teylyn
Thank you so much for your help. I am fairly new to excel and trying to figure things out. This was a tremendous help.
So how do you find that there is a space in an empty cell?
You can make a pivot table and see that there are dates, there is a " " and there is a (blank).
I'm not sure I understand about making a pivot table and see that there are dates?
If you create a pivot table and drag "Judgement Satisfied" into the rows area and into the values area, you will see that the pivot table starts with a blank cell and then has 17 dates and then has the (blank) row. That shows you that there is a dodgy date somewhere. You could double click the number and the underlying data record will show on a new sheet, but that's quite tedious.
What I did to find the cells with the spaces was this:
- Select from A2 to the end of the data in column M and turn the data into a table (Insert > Table)
- create a new column with the formula =len(h3), which will be copied down. This shows the character count for each cell.
- use the filter drop-downs to check if there are any cells with a funny character count. A date will return 5 (because it is a number with 5 digits, formatted to show as a date). Empty cells show a 0 count. Anything other than that is possibly a wrong entry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks