Load expressions from excel, different expression in same field

[HermGerm]

Hi,

I'm loading expressions from a excel-sheet, which looks like this

Data     Expression  Report
Data1  sum(value)  PL
Data2  sum(value)  PL

In the chart, I choose the Expression with this =$(=Only({<Report={'PL'}>}Expression))

Which works just fine. Now I have a dimension, which needs an other expression, but if I add this Expression into my excel, no results at all are shown in the chart

Data     Expression  Report
Data1  sum(value)  PL
Data2  sum(value)  PL
Data3  sum(othervalue) PL

Is there a way to make this work?

PS:I dont want to make a new column in the excel and then store the different expression there.

[rubenmarin]

Hi, I think your expression needs to add the Data Column to select each expression:

=$(=Only({<Report={'PL'}, Data={'Data1}>}Expression))

=$(=Only({<Report={'PL'}, Data={'Data2}>}Expression))

=$(=Only({<Report={'PL'}, Data={'Data3}>}Expression))

[Brett_Bleess]

If Ruben's post was what you needed, please be sure to close out your thread by coming back to it and on Ruben's post, use the Accept as Solution button to mark his post as the solution.  This gives him credit for the help and lets other Members know this worked.  We appreciate members that close out their threads.  If you did something different, you can post that, and then use the button to mark that post too.

Regards,
Brett