EXCEL-DATA-ANALYSIS5 MIN READ
Choose the Right Grain Before You Pivot
Choose the table grain that matches a PivotTable question.
Nina has 18,240 order lines and the VP asks for repeat purchase rate by customer cohort. The export has one row per order line, not one row per order or customer.
Read the full lesson
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in