1) How to

BuildING a trand graph by week / by brand with option to filter by region and district IN EXCEL Example of TaBLES ARE
StoreType	Brand	Region	District	Store #	City	Year / Period	Week	Order Completeness	Perfect Order%	Substituted Order%	Incomplete Order%	Item Completeness	Item Matched%	Item Substitution %	% OOS before Subs	% OOS after Subs	Order Volume
Click & Collect	BRAND B	REGION 2	316	412	Boston	202101	20210123	100.0 %	0.0 %	100.0 %	0.0 %	101.9 %	99.0 %	2.9 %	1.0 %	-1.9 %	3
Click & Collect	BRAND A	REGION 9	95	337	Baltimore	202103	20210403	100.0 %	66.7 %	33.3 %	0.0 %	102.8 %	93.6 %	9.2 %	6.4 %	-2.8 %	6
Click & Collect	BRAND A	REGION 9	95	337	Baltimore	202104	20210410	100.0 %	0.0 %	100.0 %	0.0 %	101.0 %	90.4 %	10.6 %	9.6 %	-1.0 %	3
									14.3 %	85.7 %	0.0 %	101.2 %	93.3 %	7.9 %	6.7 %	-1.2 %	7
									60.0 %	40.0 %	0.0 %	100.0 %	90.3 %	9.7 %	9.7 %	0.0 %	5