create one dimension out of multiple dimensions for chart calculation

[#1]

Hello community,

I have a bunch of "sum columns". I would like to use the column names of each column to change the expression in a chart.

Example:

Sum_Total

Sum_Basics

Sum_Material

I'm guessing that I could create one listbox out of all the needed columns and have the chart calculate the value for the selected column name.

How can I achieve this?

Thank you,

Thorsten

[bbi_mba_76 · Accepted solution]

Hi,

maybe something like the attached doc?