We really need to be able to do cross model pivots. The ability to pull referenced fields from another model. Right now it seems pivot tables cannot access related fields in other models. This is a HUGE limitation and makes adding custom fields much less useful.
The export tool can access data cross model just fine...
Example:
Sales Order pivot table that shows QTY of items sold by month, by x_studio_PRODUCT_CUSTOM, by part number
| x_studio_PRODUCT_CUSTOM | Part # | QTY Sold | |
| May | Transmitter | ||
| A123 | 33 | ||
| B123 | 785 | ||
| Lock | |||
| G456 | 12 | ||
| E456 | 58 | ||
| June | Transmitter | ||
| A123 | 12 | ||
| B123 | 434 | ||
| Lock | |||
| G456 | 34 | ||
| E456 | 464 |
