ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INTERACTIVE SALES DASHBOARD | Jan 2024 - Aug 2026 | All figures in INR
Helper cells - filter criteria used by every SUMIFS below (do not delete)
2
*
3
FILTERSRegion:AllCategory:All
Yellow cells are the only inputs. Every number on this sheet updates live based on both filters.
*
4
5
TOTAL SALESTOTAL PROFITPROFIT MARGINTOTAL ORDERSAVG ORDER VALUEUNITS SOLD
6
₹112,157,396₹27,688,03224.7%800₹140,1974,333
7
8
CHARTS (all charts are linked live to the tables below)
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
DATA BEHIND THE CHARTS (all formulas — change a filter and these numbers update instantly)
61
62
Sales by CategorySales by RegionSales by Payment Method
63
ItemTotal Sales (INR)ItemTotal Sales (INR)ItemTotal Sales (INR)
64
Electronics₹53,347,715North (Delhi)₹27,908,947Cash₹21,959,582
65
Furniture₹45,143,759West (Mumbai)₹25,829,341Credit Card₹20,958,120
66
Appliances₹9,708,471Central (Indore)₹21,020,446EMI₹21,875,080
67
Apparel₹3,957,451East (Kolkata)₹19,465,481Net Banking₹22,694,956
68
TOTAL₹112,157,396South (Bangalore)₹17,933,181UPI₹24,669,658
69
TOTAL₹112,157,396TOTAL₹112,157,396
70
71
72
Sales by Sales RepMonthly Sales TrendSales by Product
73
ItemTotal Sales (INR)MonthTotal Sales (INR)KeyItemTotal Sales (INR)
74
Sneha Reddy₹15,483,8422024-01₹5,141,529202401Laptop Pro 14₹35,149,667
75
Neha Patel₹15,084,7812024-02₹2,755,393202402Sofa 3-Seater₹25,925,280
76
Rahul Verma₹14,781,7742024-03₹4,922,102202403Smartphone Z₹16,378,820
77
Priya Singh₹14,715,5372024-04₹4,687,551202404Standing Desk₹13,260,522
78
Vikram Mehta₹13,647,3372024-05₹1,569,399202405Air Purifier₹6,494,085
79
Aman Gupta₹12,828,0562024-06₹6,348,081202406Office Chair Ergo₹5,957,957
80
Aarav Sharma₹12,812,4602024-07₹2,205,449202407Coffee Maker₹3,214,386
81
Anjali Das₹12,803,6092024-08₹4,472,069202408Running Shoes₹2,172,489
82
TOTAL₹112,157,3962024-09₹3,731,161202409Wireless Earbuds X₹1,819,228
83
2024-10₹3,630,932202410Men's Jacket₹1,784,962
84
2024-11₹3,067,920202411TOTAL₹112,157,396
85
2024-12₹2,005,838202412
86
2025-01₹3,246,917202501
87
2025-02₹2,337,667202502
88
2025-03₹3,838,886202503
89
2025-04₹3,597,109202504
90
2025-05₹3,383,872202505
91
2025-06₹5,712,727202506
92
2025-07₹2,623,690202507
93
2025-08₹2,319,900202508
94
2025-09₹1,886,442202509
95
2025-10₹5,627,734202510
96
2025-11₹1,671,559202511
97
2025-12₹3,851,703202512
98
2026-01₹2,698,927202601
99
2026-02₹4,165,596202602
100
2026-03₹3,221,658202603