Non-Selected Member Display

Unlike on the Accounts spreadsheet, non-selected dimensional members must be aggregated into the account “Other” to reconcile the report properly—for example, selecting “Illinois” in the Region dimension, the report displays as follows:

Sales/Stereos/Illinois

12.00

Sales/Radios/Illinois

6.00

Sales/Televisions/Illinois

18.00

Sales/Other

26.00

 

-----------

Sales

62.00