How to use a Hidden Table Column in Category Picker?

[it-works!]

Hi,

I have a table that looks like this:

Name: First.Name Sold

John, Doe John 50
Jenny, Bee Jenny 20
Jeff, Bridges Jeff 60

there isn't much room on the Pie chart to display the full name, so I
would like to use the First.Name for the Pie.

I would like to display the Full Name column in the table, but hide
the First.Name column, however, if I hide it, I can't use it in the
Category Filter....

any ideas?

Thanks,

Yosi

[asgallant]

Are you using a PieChart and Table in a Dashboard with the Category Filter control?  If so, you can set the view.columns option for the PieChart and Table ChartWrappers to set the columns to use to draw the charts.  See an example here: http://jsfiddle.net/2bCMq/

[it-works!]

you are awesome!

 

Thanks Much! :)

 

Yosi

[sylviat84]

On Tuesday, March 20, 2012 1:50:00 PM UTC-4, asgallant wrote:

Just what I needed to set a control on a hidden column.  Many thanks!