Using Slicers to filter column data in Pivot Table

[sparky2205]

Clamp Meter plan.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1			Usage
2	Groups	Node	January	February	March	April	May	June	July	August	September	October	November	December
3	Cleanroom AHU	1	10	12	16	11	14	16	15	9		13	11	12
4	Cleanroom AHU	2	15	18	16	15	16	15	9	8	11		13	19
5	Cleanroom AHU	3	26	32	29	30	24	28		27	31	28	29	25
6	Cleanroom AHU	4	20	22	23	28	26		28	25	29	24	23	27
7	Water Chiller	5
8	Water Chiller	6
9	Water Chiller	7
10	Water Chiller	8
11	Lighting	9
12	Lighting	10
13	Lighting	11
14	Lighting	12
15	AC Office	13
16	AC Office	14
17	AC Office	15
18	AC Office	16
19	FFU	17	226	230		246	251	234	278	226	291		258	246
20	FFU	18	171		165	159	142	186		182	193	199	178	174
21	FFU	19	189	200	212	195	193		207	203	201	164	168	199
22	FFU	20	165		169	168		158	153		157	170	162	164
23	Compressed Air	21
24	Compressed Air	22
25	Compressed Air	23
26	Compressed Air	24
Sheet1 (2)

Hi folks,
with the data above I am trying to create a pivot table with slicers and pivot chart(s) that will allow me to filter by Group at the higher level and then by Node at the next level.
I have included some sample data for two groups of nodes only. I think this should be sufficient to see what is required.
I need to be able to plot this on a pivot chart (preferably) or charts (if needed) so that when I filter by group, on the chart I will see the total for all groups plotted by month.
When I filter by node I will see the same except plotted by month for each node.
I have been attempting to achieve this using a pivot table and slicers but I haven't been able to successfully get there.
I'm not great with pivot tables so I'm hoping this is achievable.
By the way it doesn't have to be pivot tables. That's just the way my thinking brought me.

 

[sparky2205]

Hi folks,
just giving this a bump in case someone who can help just hasn't seen it.