on 10-11-2007 5:33 PM
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:
I am BI 7.0
Thanks,
Ram.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.