Hi, new to forum, and have basic excel skills - AKA - know just enought to get into trouble.
I am using one excel worksheet which I made a pivot table from to basicall allow people a different way of filtering by using slicers.
My excel worksheet has 5 main columns of data which is all related. Column 1:stand alone - default information. Column 2: Activities Column 3: Values Column 4: Recommendation for an activity/value combination Column 5: Hyperlink for recommendation if one exists.
I am currently testing out the pivot table with several user groups. I have heard the following complaints which I would like to fix.
1) The information in the top slicer (info. that is default-column 1) once clicked creates problems in the following selections - because it is stand alone value so shows up as blank on other slicers.
2) If you pick more than one option in the second middle set of slicers (col. 2)- it is not clear what the corresponding options are in the bottom slicers (col. 3).
3) People want to be able to create a report from their picks. Column 1, 4 and 5 is the information that would form a report- Column 2 and 3 are the filters. - Can i Set this up so that my mom could understand how to use this?
Any suggestions, I have attached a snip of what I am working with. There will be about 60 primary activities and about 100 values at the end of the day. So for every activity there may be up to 100 pieces of value specific recommendations.
So I am struggling on how to make this easy to use and yet provide the options. I have attached a view of the pivot table with slicers. e-guidance_snapshot.jpg
Any thoughts, suggestions welcome.
Thank you.
Bookmarks