Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have table with diffrent alternative states. Within this table there are sales data (Revenue, quantity etc.). Each alternative state have its own date filter ( MonthYear).
In each measure name i would like to have measure name and selected values from MonthYear filter.
I've tried with :
='Revenue ' & GetFieldSelections([MonthYear], 'state1')
But this works only when table alternative state is set to state1 which i cannot set as there are fields with diffrents alternative states in the table.
As for now im using this :
='Revenue '&GetCurrentSelections(chr(13), '=', ',' ,5,'state1')
It works fine but i only need MonthYear in a label, instead this gets me all of the user selections.