How to create prvot table and privot chart using Function which

[yangchen129]

My question is as following:

Please check the Attechedment for getting source excel .


We want to calculate the same Performance Attribute's Actual, Parity, Andvanced,Superior and Target

At this example we calculate Actual, Parity, Andvanced,Superior and Target according to different Performance Attribute.

The fuction which is defined by me is:

Actual = Actual1* weight1 +Actual2* Weight2+....../Weight1+Weight2....

Parity= Parity1* weight1 +Parity2* Weight2+....../Weight1+Weight2....

........

After calculation, Auto create Privot table and Privot chart by using Actual, Parity, Andvanced,Superior，Target.