Taking Average

[nuwanhwb87]

Hi,

Need to get the KPI wise Average/Total as per the Above format.

Please help

[edwin]

add the AVG/TOTAL as an aggr in the dimension, then your normal expression.  make your pivot fully expanded:
dim:  KPI, MONTH, =num(aggr(Avg(Val),KPI)/aggr(sum(Val),KPI),'#.##%')

[edwin]

this is assuming you wanted the average per KPI/total per KPI

[nuwanhwb87]

Noted with thanks.

In My Above Format Dimension is the Month , Other KPI's are Calculated Expressions.

I'm not Clear. Please explain further

[edwin]

of course you also have KPI as dimension (per your pic) not just month.  what i am saying is that aggregation is by KPI (total grouped by KPI)