Final Total In Pivot

[HirisH_V7]

Hi all,

Here in the Attached Pivot table ,

I required to calucualte Final Performance Line,

It should be , at

Dimensionality=1,

CLP *  Performace

Dimesionality =0,

Total of that above line .

But,when i  select each states it should give relative individual Percentages.

PFA,

Thanks in advance,

Hirish

[HirisH_V7]

Actually ,

I m not concern about the main total for performance .

final performance line summation required.