Variable Input Drop Down Box Generate Table Dimension Display

[Kelliesy]

I have 3 measures that I want a user to be able to see broken out by one of 10 different fields.  I only want the field that is selected to be displayed in the table along with 3 measures.  I've been trying to use a variable input box to create a drop down list of my 10 fields but am running into issues that I am sure is due to how I have it set up.  Anyone have any suggestions?  

Here is the best I can do to explain this;

If I select Segment from the Variable Input drop down, I want my table to show Segment by Total Amt, Total Rev, and Total Lost.  I want the Segment field to be in my table also.  In my Variable Input drop down I need to have all 10 fields selectable but only displaying with the 3 measures if selected.  

When I created my variables I named it FieldName.  I have Segment as the default and then 9 different fields as alternatives.  If I put my 3 measures on a table with one dimension that I point to the FieldName variable it errors and shows either no data (when I have validated there should be) or it shows - .  

[rubenmarin]

Hi, if the variable has values than equals the fields names, it should work setting a dimension as:

[$(FieldName)]

Is that the syntax used? or how are you setting the dimension?

[Kelliesy]

I've tried that syntax a few times and every time it says "Error In Expression".  I'm attaching some examples to show how i have the variable set up, the variable input set up and the error I get when I try to set up the dimension the way you explained.  I'm not sure what I am missing.  

Also, when I set up my variable input with a few alternates and try to select a different one it always changes back to the last field name that I added as an alternate.  So odd. 

[rubenmarin · Accepted solution]

Hi, attached there is a working example using [$(FieldName)]

You can check the differences with your app.