Making a dashboard from database with pivot charts that need to show SUMs and be multilingual. Considering best approach and my idea is:

Step 1: Create necessary pivot tables from data source for all charts.

Step 2: Gather necessary data such as SUMs from pivot tables in separate tables used for charts on dashbboard via GETPIVOTDATA function.

Step3: X Axis values and chart titles on separate translation table. Via select language drop down using HLOOKUP dynamically change Language on chart X axis and title...

How does it sound to you? Any other approach to consider?