Final Total Caluculation

[HirisH_V7]

Hi all,

Here in the attached application .

I want to create performance Grand Total . It should be sum of all Clp* Performance Of all states.i created like that . But when i select a single State its showing wrong performance.

Please help me out .

Thanks in advance ,

Hirish

[preminqlik]

what you req exactly can you make output excel and send for your application pivot table

[Anonymous]

What exactly you want?

As per your logic Clp* Performance, it is giving you right data.

Nothing wrong in it.

[HirisH_V7]

Hi,

In the application i want to have when i select two states the Grandtotal performance should be Like this,

as attached in the excel sheet.  

89.55

Thanks for your response,

Hirish

[Anonymous]

IS this?

PFA..

[Kushal_Chawda]

Please see the attached

[HirisH_V7]

No, If i select M1 and M2 it should be  Finla performance grand total should be 89.5

Thanks,

hirish

[vipin_mishra479]

Please check this may be help full

[HirisH_V7]

Hi vipin.mishra479,

Please check the attachment . i made a Change in dimension. Help out . how to create final performance.

Thanks,

hirish