This content has been marked as final. Show 4 replies
If helps pls mark
Hi,1 person found this helpful
In the criteria create one more column with formula as
100.0 * "Sales Facts"."Amount Sold" / REPORT_SUM("SH"."Sales Facts"."Amount Sold" BY ) ....this gives you the same result as percentage in Pivot table.
Replace Amount Sold by your measure column % of transactions.
Now set the conditional formatting in Criteria tab using this column. i.e if *100.0 * "Sales Facts"."Amount Sold" / REPORT_SUM("SH"."Sales Facts"."Amount Sold" BY ) > 50* then RED or whatever you want.
Hope this works.
Can you explain me the meaning of REPORT_SUM() .is there any other functions like this.
I have a report with transaction type,year,month ,no of transactions.If i do report_sum() i get sum of no of transactions of all months .but i need sum of transactions for that month alone.
Edited by: 8826 on Nov 15, 2012 3:45 AM
REPORT_SUM() function is applied by OBIEE to calculate report based grand total.
If you want sum at Month level you can do SUM("no of transactions" by Month).
Let me know how it works out.