Resolved: I don't get the same result as the video.
in
Data Analysis with Excel Pivot Tables
/
Creating a Master Pivot Table: The main data source for the FMCG report
I practiced from the resources and following step by step but not getting the same result. Is there maybe something that Im missing? In the photo you see
2 answers ( 1 marked as helpful)
I see that I have to change Count to Sum in the Values. Why is it Count when I select it instead of Sum Like in the video?
Hi Tom,
Good to hear from you.
Excel does that as a default setting. You'll need to adjust to ''Sum of'' manually. Great job at spotting the reason why you had different results. Means you've internalized what we've shown in the lessons. Please let me know if there are other issues along the way.
Best,
Ned