Hello and good day. I have created several dashboard pages containing both a Bubble Charts and Cross Tabs for several key metrics my organization is tracking. The goal would be to allow users to drill from either a specific bubble or table entry to view the details that comprise it. Unfortunately, the Measure values being displayed (both size and color) are summary fields, but the view I am attempting to drill down to is for individual records (Number or units with outstanding paperwork, for example). If I add Unit Number to either the chart or table, both expand to the finest granularity and no longer provide summaries. Is there any way to "Hide" the Unit Number field without added additional bubbles (images below show before and after) or rows?
One option may be to keep the above view as is. Then, create a second worksheet that shows the more detailed view. A filter action could be added to the first sheet to the second that will allow the user to drill down further.