GetFieldSelections() with result like vlookup

[Anonymous]

Hi,

I have a scenery that I have month with a different dispose of the normal.

I have one table from excel and one table inline (with two columns: Month and Month Name).

I want to get the selection from Month Name and use the respective value of Month.

The GetFieldSelections() just works if I click directly over the field "Month".

The example is in attachment.

How could I make this?

Thanks!

Regards,

Debora

[Gysbert_Wassenaar · Accepted solution]

Try =sum($(='[Month ' & Month_test & ']')). See attached qvw.

[Anonymous]

Hi Gylbert!

It works perfect actually!

Thank you!

Regards,

Debora