Classify Google Sheets metrics by whether they are additive and whether they match the row grain.
2x2-matrix classification principle-card Matches source row grain Different grain Same grain Safe to sum Do not sum Sum safely Use directly Same grain and additive Example: monthly payroll amount in an employee-month table. Pivot sums are usually safe. tl Separate table Different grain but additive Example: department headcount repeated on employee rows. Store it in department-month grain before aggregating. tr Calculate output
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in