Run the PMI report tool from NX. You may need to modify your tool bar to add it. What it does is pull all PMI types into the excel file with the PMI data ie qty size etc. the excel file winds up being about 132 columns.
Assuming somewhere in the 132 columns is the data you need for each PMI "dimension"...
Write a VBA program to massage the data from NX & output as required.
Without knowing more, and assuming the NX output is a single sheet in Excel, I'd probably
- Make a new sheet
- Run thru the existing sheet row by row, massaging as required & output to a row on the new sheet
- When done processing all rows, delete the old sheet
- Save the .XLSX
Production: NX10.0.3.5 MP16/TC11.2
I'd rather be e-steamed than e-diseaseled