%age Alongwith the Actual Value

[cogprog]

Hi,
I want to display % of row total for each column along with the actual measure value in the powerplay report. When I am clickiing Explore->Show Value As %Of Row Total. I converts the origional value to % but I need The value too be displayed in adjuscent column.
Report required looks like this

Shop Jan/2002 Feb/2002
Revenue %Revenue Revenue %Revenue
ABC 12000 24% 38000 76%
PQR 10000 10% 90000 90%

This report(Revenue) drills through to a details report. So drill through has to work on %Revenue too.

Cogprog.

 

[GJParker]

unfortunately Powerplay Explorer will not let you do what you require, the only way to do it is to create the report in Reporter mode and manually add in your Percent calculations.

Hope this helps Gary Parker
Systems Support Analyst