MichaelLeonard

Hi Everyone, I have a related question/example. I have a data set where each row represents either an on-time shipment or a late shipment (data is a 1 for on-time, 0 for late) and the shipments fall into different categories (materials, components, etc) also noted on each row. There is also a date for each row so you can…

I second this issue. I'm relatively new to all this, but I'm struggling with summarizing data as well and a pivot table does what I need so easily. We really need this type of functionality! Michael

I think I fixed it and found the bug. Changing the data after the file has been uploaded does not impact how the data is defined (as Long or as Double). I took the exact same data set and reuploaded it after changing the value and it came in as a Double instead of Long when I added some decimals.

I can't for the life of me figure out why this is happening and preventing me from blending two nearly identical data sets. I've tried adding decimal places to numbers and removing them and I can't figure this out. The blend wont work until I get that Volume field to come in as a "Double." Loosing mind...please help.