This question is only for a true Pivot Table Guru. I am already pretty good at Pivot Tables, but this one problem is beyond my abilities.
My current Pivot Table creates subtotals customer orders and shows the quantity of each part.
I also want it to show the price and total value (qty * price). But, I want it displayed inthe very particular way
which is shown on the attached screen shot.
Can any Guru show me how to do this fancy stuff with Pivot Tables without ugly workarounds.
For instance, I already know a bunch of workarounds to get my desired result:
I could copy the table and manually adjust it.
I could write a macro to automate those manual steps.
I could show quantity * price as a "side by side" field using options > calculations > calculated fields.
And, I found some other workarounds here
But, I am hoping someone can show a more elegant solution