Explained correct pivot table setup, selection issues,and proper refreshing to ensure accurate summaries.