SAP Webi - Sorts


Advertisements

Sorting can be applied in table on sections, charts to organize the data in a specific order in a Webi report. Default sorting that is applied in a report is from left to right order of objects in Result object of Query Panel.

You have the following Sorting Orders −

Default − This is default order where data is sorted as −

  • Ascending numeric order for numeric data

  • Ascending chronological order on date

  • Chronological order for months

  • Alphabetical order for alphanumeric data

  • Ascending − In this, smallest value at the top to highest value at the bottom. Example − 1000, 2000, 3000, or Delhi, Kolkata, Mumbai

  • Descending − In this, highest value at the top to smallest value at the bottom

Custom − Using this, you can define your own sort order. Custom orders are available on dimensions and attributes and not on hierarchies, measures and level.

How to Insert a Sort?

To insert a sort, open report in Design mode. Select the Column you want to sort.

Go to Analysis → Display → Sort → Ascending/Descending

Insert a Sort Sort Design mode

You can apply multiple sorts in a single table on different columns. You can use ‘Remove All Sorts’ option to delete all the sorts.

To manage the Order of Sorts, go to Advance tab. You can define order for all sorts using up and down arrows. You can define Custom Sorts here if no other sort is applied.

Manage Sorts

This can also be used to Add/Remove Sorts.

Useful Video Courses


Video

SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas

Video

SAP Webi Online Training

26 Lectures 2 hours

Neha Gupta

Video

SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal

Video

SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal

Video

SAP MM Online Training

Most Popular

14 Lectures 1.5 hours

Neha Malik

Video

SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik

Advertisements