Forum Discussion
Help with GETPIVOTDATA and Dynamic Dashboard
Hi All, I need some help with the GETPIVOTDATA function and setting up an interactive dashboard. I have a PivotTable that shows the grade percentage for each student in a certain class. On m...
Hi Anthony,
If with slicers you may do cascading set of them, e.g. one slicer filters by first letter of the name (A, B, C...), second slicer is with names itself.
Hi Sergei,
Thank you for the quick response. I did not realize that slicers had a cascading ability. Thank you for the info. The only thing in concerned about is if someone were to select more than one person, would it affect other areas on my dashboard? I only want them to be able to select at most 5.
Thank you for the quick response. I did not realize that slicers had a cascading ability. Thank you for the info. The only thing in concerned about is if someone were to select more than one person, would it affect other areas on my dashboard? I only want them to be able to select at most 5.
Anthony,
Afraid I didn't catch what you'd like to do exactly.
Slicers are connected to your tables/pivot tables/pivot charts. You may connect the slicer to only one such object or to few ones - if all of them are on same data source.
If you mean to select only up to 5 elements by slicer and not more - nope, that doesn't work.