Import Calculations

[patroser]

Hi there,

it feels like being stuck right in front of the solution to my problem, but I can't really figure it out.

I guess I missed something pretty easy...

I have an excel sheet containing some IDs and some calculations.

What I'm trying to do, is display a chart with the IDs as dimension and the result of each IDs calculation.

I tried using "$(=only({<ID={$(=RowNo())}>}Expression))" assuming, that RowNo would return the correct ID for each Row.

Is there any clean way to calculate each expression for each ID? Worst case could be, that the ID is alphanumeric, therefore RowNo wouldnt work.

Please find attached the example.

Thanks in advance

Patrick

[Gysbert_Wassenaar · Accepted solution]

See jonathan dienst‌'s reply in  this discussion: Expressions in Fields

[patroser]

This works for me, thanks!

I just didn't know, that the $-Expressions are evaluated outside the context of the charts dimension.

Patrick