Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I did not get you.
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?
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