Hi,

I want to show the cross tab report with percentage value. Actually i want to know the machine utilization in a month which means how much percent the machine was utilized in a month.

ex: i have 4 machines and each machine will run in daily basis for the whole month based on the planning but few machines break down in a month.
       
percentage formula: (Plan days/Days in month)*100
   Jan Feb March April
1 80% 70% 65%   89%    
2 10% 20% 10%   20%
.
.
.

I tried the report i am getting only count of plan days but i am not sure how to apply the percentage formula.

please help me.

Regards,
Kiran.