sparky2205
New Member
Hi folks,
with the attached data 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 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.
If further clarification is required please let me know.
with the attached data 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 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.
If further clarification is required please let me know.