Can you please explain how to fill the table GETPIVOTDATA in practice exam 2?
in
Data Analysis with Excel Pivot Tables
/
This is how the report can be used in practice by high-level executives
You say in the exercise question 3 if i remember correctly, to fill the Table sheet. I'm not sure how to do that, it only works with New Sheet. Then to use getpivotdata to fill the table. if you gave the answer completely step by step it would help very much. Thanks in advance.
3 answers ( 0 marked as helpful)
Hi Panagiotis,
You should try to apply what we showed in the video lessons. I'm not sure which part was skipped.
Best,
Ned
Thanks. I understood what was being asked. You didn't want me to to make the pivot table and the end table one entity, as i thought initially, which would rather be impossible. You simply asked to draw data from it, and fill the other table in.