Skip to Content
BW Business Explorer (SAP BEx)

How to change order of Keyfigures in reports

Purpose:

Sometimes in reports it is required to change the order of keyfigures during runtime.

Overview:

You execute the report and want to compare or view the data based on a particular order of keyfigure during runtime.

You don’t want to change the order of keyfigure in Query Designer but only want to change during runtime for that execution

Steps to follow to change the order of Keyfigure

  • Execute Query in Java web
  • Do right click on Keyfigure
  • From keyfigure context menu
  • Select Filter -> Select filter value
  • Change the order or keyfigure as per your requirement
  • Click ‘Ok’.

Now you need to follow the below steps to get the order of keyfigures correctly displayed as per changed order.

  • Do right click on Keyfigure
  • From key figure context menu
  • Goto Properties
  • Select Characteristic

Key figure property window opens up.

In the Properties of Key figures

  • Goto ‘Sorting’ tab
  • Select Sort by -> Selection

This will sort the the order of keyfigures during runtime.

Former Member