GROUPBY + Slicer

[LearningByDoing]

Hello,
I am currently experimenting with the combination GROUPBY + Slicer, as Mike Thomas shows in the video on YouTube, but my combination is not working as desired. Maybe I just have tunnel vision and don't see the ‘problem’. Hence my request for help.

Below is the screenshot with the slicer, which only works with the name ‘Miki’, but not with the other names.

Thanks in advance

groupby-slicer.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1
2	Date	Person	Sales	Filter		Person	Sales
3	Jan	Miki	1645,01	1		Chantel	16365,47
4	Jan	Miki	4828,54	1		Jo	5628,43
5	Jan	Chantel	3634,56	1		Miki	16071,94
6	Feb	Chantel	2713,46	1		Tyrine	13794,66
7	Feb	Miki	679,07	1		Total	51860,5
8	Feb	Tyrine	1526,73	1
9	Mar	Tyrine	3151,76	1
10	Mar	Jo	3554,02	1
11	Apr	Tyrine	3409,51	1
12	Jun	Jo	458,09	1
13	Jul	Chantel	2140,04	1
14	Aug	Chantel	3361,29	1
15	Aug	Miki	3882,28	1
16	Aug	Tyrine	3223,12	1
17	Aug	Chantel	1608,7	1
18	Sep	Tyrine	98,57	1
19	Sep	Jo	1616,32	1
20	Sep	Chantel	2907,42	1
21	Oct	Miki	554,62	1
22	Oct	Miki	4326,08	1
23	Nov	Tyrine	2384,97	1
24	Dec	Miki	156,34	1
25
Sheet1

Cell Formulas
Range	Formula
F2:G7	F2	=GROUPBY(tbl_data[[#All],[Person]],tbl_data[[#All],[Sales]],SUM,3,,,tbl_data[[#All],[Filter]]=1)
D3:D24	D3	=SUBTOTAL(103,A3)
Dynamic array formulas.

 

[Fluff]

In what way doesn't it work with the other names?

 

[LearningByDoing]

@Fluff
... if I set the filter to a different name, the following result appears

... and this is repeated for Chantel and Tyrine ... only Miki the slicer like

 

[Fluff]

That's because you are hiding rows. Move the Groupby formula to below the table & everything should be fine.

 

[LearningByDoing]

@Fluff

... you must have rolled your eyes. Such a ‘stupid mistake’ and I didn't see it.
Thank you very much and have a nice day.

 

[Fluff]

You're welcome & thanks for the feedback.