I am struggling to get data in pivot table to appear correct. Some data show up correct, but in the example below, two records with the same timestamp won't, but others will. Any clues as to how this is?
The 'Create Task' and 'Create Taks PutTask' records, time 11:50:00 show up correct, but the Maintenance column shows at it's own line.
I've stored the table in my script and done a csv import in excel. - The data for the upper yellow box is shown below. I Only sum data which in Double column are True. Expected result is that 'Create Task PutTask and Maintenance show up on the same line, but in their respective columns:
This shows up right in the pivot table (everything expanded), but for the Maintenance record. I agree that it probably is data related, but I have checked the Date and Time and they and have null in their respective time and date parts, and I am clueless.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.