Forum Discussion
How to activate only some Row Subtotals based on Columns
Hi Everyone,
I am struggling with how to not display some of the rows subtotals. I want to display Jawad, Audi, RS6 like it is on the 3rd row from the table but I do not want the 2 subtotal rows above to display any data on Dealer, Brand and Model. Any idea on how I go about that ?
I want to keep the subtotals for the rest of the columns.
Appreciate the support here !!
/Jocelyn
2 Replies
Hi Jocelyn1234 ,
You can try this:
- Ensure All Top-Level Categories Are Visible: Click the Drill up icon to make sure the matrix shows all top-level categories.
- Selectively Display Subtotals: Right-click on the row for which you want to display subtotals (e.g., Jawad, Audi, RS6) and navigate through the "Expand" options.
- Choose to Expand: Select Expand > Selection from the menu. This action will display a total row for each category you've selected while keeping the rest of the subtotals as per your requirement.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
thank you for your answer.
I want to get to that table from the previous one. Hope that clarify !
