Difference between revisions of "Asymmetric Grids"

(Created page with "==Asymmetric Grids== XLCubed has three quick select options on the right click menu for a grid. ‘Keep only’ retains just the highlighted members, while ‘Keep all Except...")
 
m (Text replacement - "XLCubed" to "FluenceXL")
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==Asymmetric Grids==
 
==Asymmetric Grids==
  
XLCubed has three quick select options on the right click menu for a grid.  ‘Keep only’ retains just the highlighted members, while ‘Keep all Except’ removes the highlighted members. The third option ‘Exclude from Display’ allows for the creation of Asymmetric grids.
+
FluenceXL has three quick select options on the right click menu for a grid.  ''Keep only'' retains just the highlighted members, while ''Keep all Except'' removes the highlighted members. The third option ''Exclude from Display'' allows for the creation of Asymmetric grids.
  
  
 
For example you may want to display only budget for future months and only actuals for historic months.  
 
For example you may want to display only budget for future months and only actuals for historic months.  
To achieve this select the items which you want to remove, and on the right click menu select ‘Exclude from Display’.  
+
To achieve this select the items which you want to remove, and on the right click menu select ''Exclude from Display''.  
Note this is only applicable where there are two hierarchies on the axis, and the user must select elements from both hierarchies. In the example below ‘January 2004’ is being excluded specifically for Australia.
+
Note this is only applicable where there are two hierarchies on the axis, and the user must select elements from both hierarchies. In the example below ''January 2004'' is being excluded specifically for Australia.
  
[[image:AsymGrids1.png|centre|350px]]
+
[[image:AsymGrids1.png|centre|500px]]
  
 
Excluded items can then be viewed, and deleted from the report designer via the information icon which appears on the relevant axis as shown below on columns.
 
Excluded items can then be viewed, and deleted from the report designer via the information icon which appears on the relevant axis as shown below on columns.
  
[[image:AsymGrids2.png|centre|350px]]
+
[[image:AsymGrids2.png|left|350px]]
 
+
[[image:AsymGrids3.png|right|350px]]
[[image:AsymGrids3.png|centre|350px]]
 
  
 
[[Category:Grid Reporting]]
 
[[Category:Grid Reporting]]
 
[[Category:Formula Reporting]]
 
[[Category:Formula Reporting]]
[[Category:OLAP operations]]
+
[[Category:OLAP Operations]]

Latest revision as of 16:04, 3 July 2023

Asymmetric Grids

FluenceXL has three quick select options on the right click menu for a grid. Keep only retains just the highlighted members, while Keep all Except removes the highlighted members. The third option Exclude from Display allows for the creation of Asymmetric grids.


For example you may want to display only budget for future months and only actuals for historic months. To achieve this select the items which you want to remove, and on the right click menu select Exclude from Display. Note this is only applicable where there are two hierarchies on the axis, and the user must select elements from both hierarchies. In the example below January 2004 is being excluded specifically for Australia.

AsymGrids1.png

Excluded items can then be viewed, and deleted from the report designer via the information icon which appears on the relevant axis as shown below on columns.

AsymGrids2.png
AsymGrids3.png