I have a pivot table I'm trying to run a bar chart from, but there are 35 results (too many) however 20 of these results are under 10% of the results.
Is there a way to group results under X, either in the pivot table or chart/graph.
Thanks
I have a pivot table I'm trying to run a bar chart from, but there are 35 results (too many) however 20 of these results are under 10% of the results.
Is there a way to group results under X, either in the pivot table or chart/graph.
Thanks
Note that I do not have a 2003 version of Excel with which to test the following and that it will require some tediousness in writing a Calculated Item.
As modeled in the attached file the Less than 10% Group is a calculated item that reads: =AA +AB +AC +AD +K +L +M +N +O +P +Q +R +S +T +U +V +W +X +Y +Z
A value filter is then applied to show only those attributes with a value of 10% or more.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks