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 be a bug, but I know that Excel does not do well with "ragged hierarchies" or hierarchies in general.
Exhibit A: normal format for 50001. 51800, 52300
Exhibit B: 50001 is the only account that has a subaccount, yet 50001, 51800, and 52300 are all treated by Excel as row headers, meaning that it thinks that 51800 and 52300 have subaccounts (yet they don't)
The Measure for each column contains:
VAR Val = [Measure]
VAR AccountShowRow = [[DAXP]] AccountBrowseDepth]<=[[DAXP]] AccountRowDepth]
VAR Result =
IF ( AccountShowRow, Val )
RETURN
Result
The formula itself works as expected, however the treatment of a parent with no child as a row header, does not.
Exhibit A: normal format for 50001. 51800, 52300
Exhibit B: 50001 is the only account that has a subaccount, yet 50001, 51800, and 52300 are all treated by Excel as row headers, meaning that it thinks that 51800 and 52300 have subaccounts (yet they don't)
The Measure for each column contains:
VAR Val = [Measure]
VAR AccountShowRow = [[DAXP]] AccountBrowseDepth]<=[[DAXP]] AccountRowDepth]
VAR Result =
IF ( AccountShowRow, Val )
RETURN
Result
The formula itself works as expected, however the treatment of a parent with no child as a row header, does not.
