Hey Guys,
I'm Trying to create a pivot off a pivot and paste in a seperate sheet. I tried recording it but am receiving an error, thus, im hoping I can have some assistance here.
Essentially, we want to go in "Sheet A" The pivot is from Column H to Column Q. We want to report filter for "option A" which includes "A" "B" "C" "D" categories. For Column Labels have "option B". For Row Labels have a breakdown by "Option C". For Values have a breakdown by "Option D" and value field settings to be average.
From this point we'll copy this pivot and paste in "Sheet Z"
Can someone advise?
Thank You
Bookmarks