Hi Folks,
In the attached spreadsheet I have a pivot table that shows the need over a defined period for inverters, there can be up to 3 inverters per order and I need to change the way that the item count is shown as its "too busy" for easy reading which is the aim of the pivots on this report.
I am uncertain how to get the best result as the inverter type can change across Inverter 1, 2 and 3 as can be seen in source data in the sheet 'Today's Data'.
Thanks in advance.
Iain Kennedy
Bookmarks