Treat the historical SC splits as well as the margin, as just another store attirbute, just like totaly month gross revenue (total_gross_by_DS) They should be unique by DS. Create a key on them, and continue as normal for now (1) Sum each stores revenue (2) Breakdown by percentages (3) Breakdown revenue by percentages from OA (4) . . . . # (1) Total By Store # (2) Match to storeid in OA (at least top stores) # (3) Ingest whole table. DS_Scratch.mbworkbook ---- Create Summary Tables (1) Determine What fields / data I want to see (2) Talley up summaries from DS_Scratch.mbworkbook (3) Talley up summaries from DS_Scratch.GPU ----- Cleanup TODO's posix dates in Aggregated_* are being set to wrong TZ