I probably should have listed the specific things I had tried. I had tried your suggested solution, but it unfortunately also did not work.
I'm not sure how to create a sample other than to type out the dimensions and expressions, and mock up what the final table should look like. As far as I know, I can't access the back-end or load script, so I'm not sure what the raw data looks like.
If adding the additional information I mentioned will be helpful, please let me know and I'll add it in there.