Displaying sum of pivot table values in Gauge chart

[#1]

Hi Everyone,

i have pivot table with a cyclic group and have an expression square.

i want to display the same expression in a gauge chart when i do a particular selection in the cyclic group(Pivot table)the total value in the pivot table should be reflected in the Gauge chart also.

For eg :

Counterpart-0.40

Tradetype-0.96

Strategy-0.80

Please find the attached file and let me know the solution.

Regards,

Hari

[Gysbert_Wassenaar]

See attached qvw