Skip to Content
author's profile photo
Former Member

% 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


Result Row:

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 11, 2007 at 04:39 PM

    I am BI 7.0



    Add comment
    10|10000 characters needed characters exceeded