% Calculation on Overall Result Row with Condition
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