Sales and Forecast Dashboard
Data Input
Transaction Daily Record
Appx Product
Forecast Table Group Product
Comparison Forecast and Sales
Group By Col Without Date
Customer Comparison
Budget Comparison
Paste Data Tables
Forecast Table (Upload Excel file, with Headers, Dates in dd/mm/yyyy):
No file selected
Transaction Sales Table (Tab/Comma-Separated, with Headers, Dates in mm/dd/yyyy):
Transaction Qty Table (Tab/Comma-Separated, with Headers, Dates in mm/dd/yyyy):
Process Data
⏳
Transaction Daily Record
Customer ID:
Remove
Add Customer ID
Generate
Unique Product Table
Merged Forecast Table with Product Info
Comparison Forecast and Sales
Group By Column:
Selected Groups (comma-separated, leave blank for all):
Remove
Add Selected Groups
Customer ID:
Remove
Add Customer ID
Generate
Group By Col Without Date
Group By Column:
Selected Groups (comma-separated, leave blank for all):
Remove
Add Selected Groups
Customer ID:
Remove
Add Customer ID
Generate
Customer Comparison
Filter Column:
Selected Products (comma-separated):
Remove
Add Selected Products
Customer ID (leave blank for all):
Remove
Add Customer ID
Generate
⏳
Budget Comparison
Customer ID:
Budget Constraint (RM):
Remove
Add Customer ID
Generate
⏳