Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
You could create a drill down dimension group consisting of your fields "ShipCity" and "ShipCountry" and use this in a ListBox.
regards
Marco
maybe like this:
regards
Marco