Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to display the "Total" of all Customers in Bex query with Condition for displaying Top 10 Customers

Hi Experts,

I have a requirement in which in a query i am displaying the top 10 Customers in columns. But as per the customer's requirement i have to display the Total values of the key figures in a seperate column irrespective of the top 10 being displayed.

For example if i am having 50 customers i am right now displaying the top 10 Customers for various key figures like Material cost; Revenue; volume etc which are in rows and these are Restricted Key figures.

The output of the query depends on multiple selection parameters like Scenario; Different Channel values; Different Segment values; Year and period selection as well and hence depending on the selection made the query has to dynamically give the output.

Kindly help me in a way so that i can get the TOTAL of Key figures of all the customers irrespective of the Top 10 customers being displayed in the same query .

Your valuable inputs would be appreciated.

Regards

Naveen Chand Yalamanchili

Tags:
Former Member
replied

Hello Naveen,

In your query activate the result line for your customer . if you have put condition for Top 10 customers the result value will give you the total value for all the customers put together. Conditions doesn't impact the result line

Regards

Gajesh

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question