Am currently working on a requirement wherein the Client wants to see an Chart based on Percentages, this is a major advantage in upcoming OBIEE Version 11.1.1 Release.
Seems like this is a Bug & would be resolved in OBIEE 11g major release.
The bug id is as follows
Am pondering for a Workaround.
My Oracle Support Says:
Change request CR 12-IWEVPD “Charting of Pivots – Aggregation and Show As not used in Charting” has been logged to add this functionality in future versions of the product. Currently there is not workaround to chart pivot data in the format it is displayed in the pivot table (percentage of row instead of raw data).
Analytics – Answers – No way to Chart on Percentages that are created in Pivot Tables [ID 535318.1]