Drilling down on an individual member in a hierarchy drills down for all members.
The ability to drill down for individual dimension members is only available for multi-dimensional data sources, and is not currently available for relational data sources.
Workaround 1
Use Filter Actions. When you use filter actions, a selection on one view in a dashboard can filter the other views on the dashboard.
Workaround 2
1. Create a set from Category dimension using all values. Name it Category Set
2. Create a calculated field called Expand with the following formula:
if [Set 1] then [Sub-Category] else "" end
3. Add Category and Subcategory to rows with Sales or any other measure on Text
4. Go to Worksheet -> Actions -> Change set values with the below configurations
001473673
1276 KB
1345 KB
1173 KB

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.