Column Header for Table/ Matrix

[RAHULBANDI]

Hi Friends I have Following Datasets

requirements: 

1)  Format of the data 

2. Add 2 slicers on the same page – “Top Customers” slicer and “Date Range” slicer

Top Customers – This slicer contains 3 values – [Top 10, Top 20, Top 30].
If someone clicks on Top 10, only those Customers should get filtered whose Total amount (Offline + Online combined) is falling in Top 10 (by descending order).
Similarly, if Top 20 is clicked, then top 20 customers by total amount should be filtered, etc.

Date Slicer – Create a Date range slicer based on the sale date

Expected Result:

Additional screenshot:

--If someone clicks on “Top 10” in the Top Customers slicer, then, only Top 10 customers by Total Amount should be filtered as shown in the below screenshot

[v-henryk-mstf]

Hi @RAHULBANDI ,

After testing, the data you provided seems to be problematic and does not yield the expected results, can you explain further?

Looking forward to your reply.

Best Regards,
Henry

[RAHULBANDI]

Data-set for the above scenario:

Sale Date	Type of Sale	Customer Name	Sale Amount	Units Purchased
1-Jan-22	Online	Customer19	258	153
1-Jan-22	Online	Customer22	2933	173
1-Jan-22	Online	Customer33	10909	120
1-Jan-22	Online	Customer37	3247	155
1-Jan-22	Online	Customer67	1747	197
1-Jan-22	Online	Customer67	6217	159
1-Jan-22	Online	Customer68	1435	102
1-Jan-22	Offline	Customer68	4967	135
1-Jan-22	Online	Customer8	3500	184
2-Jan-22	Offline	Customer13	5657	113
2-Jan-22	Online	Customer35	5180	113
2-Jan-22	Online	Customer51	5614	167
2-Jan-22	Online	Customer53	2379	155
2-Jan-22	Offline	Customer69	2294	122
2-Jan-22	Online	Customer69	8405	149
2-Jan-22	Offline	Customer69	4520	102
2-Jan-22	Offline	Customer69	17307	147
2-Jan-22	Online	Customer69	920	170
2-Jan-22	Offline	Customer69	2909	177
3-Jan-22	Online	Customer46	55536	115
3-Jan-22	Online	Customer53	4280	129
3-Jan-22	Offline	Customer55	9644	116
3-Jan-22	Offline	Customer70	3377	185
3-Jan-22	Online	Customer70	12737	162
3-Jan-22	Online	Customer70	1817	139
3-Jan-22	Online	Customer70	6497	194
3-Jan-22	Online	Customer71	749	160
3-Jan-22	Online	Customer71	2226	132
4-Jan-22	Offline	Customer45	4180	150
4-Jan-22	Offline	Customer49	4814	148
4-Jan-22	Offline	Customer51	3857	166
5-Jan-22	Online	Customer25	4363	124
5-Jan-22	Offline	Customer46	12695	182
5-Jan-22	Online	Customer17	5962	115
5-Jan-22	Offline	Customer17	3043	172
6-Jan-22	Online	Customer26	1870	166
6-Jan-22	Offline	Customer30	3610	141
6-Jan-22	Online	Customer46	14076	171
6-Jan-22	Online	Customer48	1571	199
6-Jan-22	Offline	Customer5	8341	194
6-Jan-22	Online	Customer50	65174	192
7-Jan-22	Online	Customer34	8741	153
7-Jan-22	Offline	Customer37	2823	158
7-Jan-22	Online	Customer46	14076	118
7-Jan-22	Online	Customer6	3358	164
8-Jan-22	Offline	Customer20	25996	113
8-Jan-22	Online	Customer28	10494	126
8-Jan-22	Online	Customer35	5547	195
8-Jan-22	Online	Customer53	7075	135
8-Jan-22	Offline	Customer55	9644	164
8-Jan-22	Offline	Customer9	4330	196
9-Jan-22	Offline	Customer12	5174	118
9-Jan-22	Offline	Customer12	20193	126
9-Jan-22	Online	Customer15	5296	113
9-Jan-22	Online	Customer23	5353	186
9-Jan-22	Online	Customer56	15309	149