Pie chart from a single row

[Rickard_Abraham]

Ah gotcha, funny you’re talking to me then, I made a suggestion 10 months ago for new column formulas. So I’m afraid this specific approach is currently not possible without hard-coding

New formulas for columns

Goal Dynamically select a column from a table Issue The current possible approach forces you to repeat yourself into a coupled mess: Select Options Formula List("Population", "Area", "Density", "GDP", "Elevation", "Temp") Dynamic Column Formula Switch( [Select], "Population", thisRow.Population, "Area", thisRow.Area, "Density", thisRow.Density, "GDP", thisRow.GDP, "Elevation", thisRow.Elevation, "Temp", thisRow.Temp ) If you want to add a column you need to modify informati…