Hi all,
In a cube i have equipment & plant as characteristics, CALMONTH & CALYEAR are time characteristics & Downtime and Availability % of equipment as Key figures.
In a query i am comparing the availability of equipment over the period of three months i.e. current month, month -1, & month -2 for each equipment.
I need to calculate the average availability of all equipments over the period of three months along with the availability of each equipment. The report format is as follows:
Equipment Availability(month) Month-1 Month-2
1 98.5% 97% 98%
2 99.1% 99.0% 99.2%
Average 98.8 98 98.6
Any help would be appreciated.
Regards,
Ankit