Skip to Content

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

% Calculation on Overall Result Row with Condition

Hi all,

I have a query that displays Top N records by Revenue. I have some characteristics in rows and in columns I have a key figure structure with Total_Revenue, Labor Cost, %Labor_cost etc. , The total revenue, labor cost, .. are restricted keyfigures with Amount and cost elements. The percentage is the %share of the cost with revenue. I have a condition on the report to display only top N records by revenue.

The user wants to display the overall Result Row also. The inidividual %'s are calculating properly for individual rows. But for overall result row the %'s are wrong as it is taking into account the undisplayed rows also because of the condition. For Revenue and Cost RKF I set the calculation to Total, so the result row is calculating only the displayed values. But I cannot find any such thing for %. Since I have just one structure I am unable to use Formula collision. Any idea how to calculate % on the Overall Result Row just for the displayed rows.

My query is as follows.

Col: Total_Revenue Labor_Cost %labor_cost

Rows:------

Result Row:

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