Skip to Content
Author's profile photo Former Member

SAP Lumira 2.0 -What’s New in SAP Lumira Discovery Crosstab

Crosstabs are commonly used in representing and organizing raw data. They are best suited for displaying simple relationship between the qualitative and the corresponding categorical value and help in providing both summary and granular level details which sometimes charts fail to convey.

Let’s look at some of the new features in SAP Lumira Discovery crosstab:

  1. Context Menu
  2. Hierarchy
  3. Swap axis
  4. Number formatting
  5. Conditional Formatting
  6. Filter/exclude
  7. Sorting/ ranking
  8. Look and feel
  9. Calculated key fig


1. Context Menu

A major upgrade from the older version is the enhanced context menu. Just right click and one can access all the important feature/functionalities of the crosstab.

The New Crosstab in SAP Lumira Discovery - 2

2. Hierarchical Drilldown

Unlike the previous version, the new cross tab in SAP Lumira Discovery comes with robust drilldown and interaction capabilities. Following functionalities can be achieved using hierarchies in crosstab:

Drill up – Helps you drill a level up the hierarchy

The New Crosstab in SAP Lumira Discovery - 3

Drilldown – Helps you drill a level down the hierarchy

The New Crosstab in SAP Lumira Discovery - 4

Drill By – Similar to drill down operation. The only difference is that it displays the initial level along with the one below.

The New Crosstab in SAP Lumira Discovery - 5

Drill Path – It helps choose the drilldown path in case the dimensions have more than one hierarchy drilldown paths.

3. Swap Axis

Just like the crosstab in SAP Lumira Designer the swap axis option has been included in the SAP Lumira Discovery Crosstab as well. Thus, giving the user the ability to toggle axis on runtime.


4. Number Format

Now it is easier formatting numbers in crosstab using the number format property where one can setup their own scaling factor and decimal places with the display options.


5. Conditional Formatting

Just like other components in SAP Lumira discovery, the crosstab can now leverage the conditional formatting rules set for the whole dashboard in general instead of component specific conditional formatting rules. Also, one can enable, disable and edit conditional formatting rule on runtime, thanks to the new context menu-

The New Crosstab in SAP Lumira Discovery - 7

The New Crosstab in SAP Lumira Discovery - 8

6. Filter/Exclude

In SAP Lumira 1.X you would have noticed that one could filter only on the dimensions present in the crosstab. With SAP Lumira 2.0 this limitation has been overcome. One can now filter on any dimension present in the data source irrespective of it being present in the crosstab.

The New Crosstab in SAP Lumira Discovery - 9

7. Sorting and Ranking

Sorting and ranking has become simpler than before as there is no need to go to the explore mode like the earlier version. Simply right click and sorting and ranking options pop up.


The New Crosstab in SAP Lumira Discovery - 10


The New Crosstab in SAP Lumira Discovery - 11

8. Look and Feel

The new crosstab just got a UI/UX upliftment with various formatting options. A simple right click will let you access a galore of formatting options.

  • Font – Font Type, Size, Bold/Italic and Color
  • Alignment
  • Background Color

Note: It is now easier for designers to directly enter the hex values in the color pallet to change the background and font color


The New Crosstab in SAP Lumira Discovery - 12

Font Color

The New Crosstab in SAP Lumira Discovery - 13

Background Color

The New Crosstab in SAP Lumira Discovery - 14

9. Calculation

Overall the calculations have remained same, except for becoming readily accessible under the context menu
The following are the runtime calculation which can be created in the crosstab:

  • Counter
  • Running Calculations
  • Moving Average
  • Percentage off
  • Difference from
  • Custom calculation

The New Crosstab in SAP Lumira Discovery - 15

So, to sum it up, the crosstab has become more robust in terms of interaction, look and feel. Thus, giving the end users easier navigation and enhanced run time capabilities


For interesting use case on SAP Lumira Designer crosstab please refer – Images within table in SAP Lumira Designer

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      Hi Bhupinder,

      Your blog highlights very well the new features available in the Lumira Discovery standard Crosstab component.  However, I'm not sure about the relevance of the "interesting use case on SAP Lumira Designer crosstab" link you have specified because it is not actually related to the standard Crosstab component.



      Author's profile photo Former Member
      Former Member

      Thanks Bhupinder.


      Do you know if there is a way to repeat members in crosstab ? We can do this in AFO but did not see this option in Lumira.

      Author's profile photo Lakshmikanth Adharapurapu
      Lakshmikanth Adharapurapu

      Hi Naveen,


      you need to do it in the cross tab in SAP lumira designer in order to get repeat members in your cross tab.



      Lakshmikanth Adharapurapu


      Author's profile photo Amit Trivedi
      Amit Trivedi

      Hi Bhupinder,

      In ranking if i select top 3 then it shows top 3 but i want i also want one more column for others. How can i get this?

      with regards,

      Amit Trivedi


      Author's profile photo Nicholas Sinclair
      Nicholas Sinclair


      This is all really great advancements in the product.

      I have a question from a user regarding the ranking feature.

      If I rank the top 10 by the measure that is fine, but the user then wants all the remaining volume to fall in an Others category at the bottom of the table.

      I know this use to be possible in Webi with a bit of manipulation (using NoFilter syntax) but is it possible in Lumira?


      Thank you