I am using a calculated column showing the level of an account and several measures to allow children to show only when necessary. However I noticed one thing - Excel Power Pivot treats all row labels within a group as row headers (bold) even though not all have children. In my mind this would...
Question: Is there a way to tell the Pivot Table to display all row labels (values for a given field) even if it doesn't have any data for your selected column headers counts.
Thanks for any advice!