Aggregate % for year when drill up

[#1]

Hello,

Find attached, when i drill down i get 100% and when i drill p i get 1200% how do i aggregate 1200% to 100% on yearly bases as that of month. How do i do this?

Rgds

[MK_QSL]

Change expressions as below

Actual

Sum({<Description={'Pipeline Availabilty %'}>} Actual)/Sum(TOTAL {<Description={'Pipeline Availabilty %'}>} Actual)

Target

Sum({<Description={'Pipeline Availabilty %'}>} Target)/Sum(TOTAL {<Description={'Pipeline Availabilty %'}>} Target)

or

Actual

Sum({<Description={'Pipeline Availabilty %'}>} Actual)/Sum(TOTALActual)

Target

Sum({<Description={'Pipeline Availabilty %'}>} Target)/Sum(TOTAL Target)

[#3]

Hello

This didn't work out