I have data in rows that needs to be subtotaled. I am using the subtotal button, At each change in (Col B [my order ID]), Use Function Sum, Add Subtotal to (Col B).
The subtotal is working as expected, the problem is that when I roll up to level 2, I am getting the "labels" (Order ID) from Column B, but I also need the information from Column C (my SKU) to display.
I can't quite figure out how to get this data to display.
TIA for any help you could offer!
The subtotal is working as expected, the problem is that when I roll up to level 2, I am getting the "labels" (Order ID) from Column B, but I also need the information from Column C (my SKU) to display.
I can't quite figure out how to get this data to display.
TIA for any help you could offer!