MicroStrategy ONE

Banding

While this is not a tab on the Format dialog box, banding is enabled by default for the following autostyles:

  • Accounting
  • Finance
  • Colorful
  • Greybands

Banding is accessed by selecting Options from the Grid menu.

The merge header cells option, on the Grid menu, is set to false on the autostyles listed above. This option allows element names to be repeated for a unit displayed on a row of a report. For example, Country and Region are displayed on the row axis of a report. If merge header cells is set to true, the report displays as:

Country

Region

USA

Northwest

 

Northeast

 

South

Germany

Saxony

 

Bavaria

If merge header cells is set to false, then the report looks like the following:

Country

Region

USA

Northwest

USA

Northeast

USA

South

Germany

Saxony

Germany

Bavaria