Pro exercise
Total before you pivot
Build a Q1 store-by-month table. Several rows can share a store and month, so total them first; months outside Q1 are out of scope, and a store with no sales in a month stays missing, not zero.
- pivot
- aggregation
- scope
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.