Table box hide column and show selected value

[#1]

I have a tablebox with two columns "ShipCity","ShipCountry" (as per attached scree shot)

I want the data should be displayed based on filter for eg ShipCountry="France" and also the want to hide "ShipCountry" column.

[swuehl · Accepted solution]

Use a straight table chart instead of a table box.

Use two dimensions, ShipCity and ShipCountry

Use one expression

=sum({<ShipCountry = {'France'}>} 1)

On presentation tab of chart properties, check that 'suppress zero values' option is enabled and hide columns for dimension ShipCountry and the single expression.

[MarcoWedel]

You could create a drill down dimension group consisting of your fields "ShipCity" and "ShipCountry" and use this in a ListBox.

regards

Marco

[MarcoWedel]

maybe like this:

regards

Marco