Add/Remove Rows & Columns enable users to add/remove rows and columns from selected cube structure in the existing Olap Analytic.
To Add/Remove Rows & Columns, follow the steps below:
1. Drag and Drop desired elements from the list to or , the result table would be displayed in the
Drag Sales from Measures and drop it into Rows and
Drag Territory from Markets and drop it into Columns as shown in below figure
2. Alternatively, multiple columns and rows can be dropped to generate table. To Remove Rows & Columns, click on icon/button to remove row or column from Columns list and Rows list.
3. Finally click on icon to save Olap Analytic.