Forum

It's difficult to visualise your data and suggest a solution with a file to play with. Can you please upload a file (without confidential information)...

Haha. Glad I could help!

Difficult to explain, but perhaps it helps if you just think about Data (tData) and Annotated Data (tData_2). Forget about the other tables in your fi...

You may click on your own profile and then in the bottom right-had corner you find your stats including two buttons that take you to your posts.

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

I added a pivot table to your file (the green tab at the far end), believing that it does what you ask for. If not, please come back and clarify your ...

Thanks for the file. I created a self referencing query, but before I could do that I simulated a 'first data set' based on the first four columns of ...

I believe you need to use a self-refencing query. The very first time, you connect to the data, do the basic transformations (if needed) and load the ...

The file didn't attach. Please try again and this time, don't forget to press the 'Start upload' button (and wait until it's finished) before you subm...

Can't help you if you don't show me what exactly you are doing.

See if you can adapt the attached file.

You could use Power Query to connect to a location (Folder) on your system with the following script: let Source = Folder.Files("C:xxxxxxx"), #...

Thanks for the files but I don't really follow. The graph seems to be linked to data from a pivot table on your local system, so I can't see how you d...

See if the attached file does what you have in mind, using size groups and a max number of 5 sizes withing each group.

I had to google a bit to find the meaning of NCMR. My guess is that you are dealing with "Non-Conforming Material Reports". Correct? It would be he...