Retrieve certain value

[n1ef5ng1]

Hi,

I have multiple pivot table that display a certain value after doing some complex calculation.

I need to take a certain value from each table to form a new 'summary' table

is there any retrieve code or reference from this table coding to look into?

thank you

[sujeetsingh]

I did not get you.

[n1ef5ng1]

I need to generate a table for the overview of KPI. Each value in the KPI have to derive using a complex formula

Therefore, I manage to retrieved these values using multiple pivot table.

Is it possible if I can take certain value from these multiple pivot table to form a KPI table?

[n1ef5ng1]

A more detailed example

Desired Output

Indicator     Score    

A               70    

B               70

C               85

D                33

For each indicator, it carries certain formula to dervie the score, I am currently using Valuelist to generate this table layout

I am able to derive the score by having multiple pivot table, each pivot table carries one score ( complex formula)

Therefore, how can i Compile all the score that is generated using multiple pivot table