I have a pivot table(chart) in which I am using a cyclic group to cycle through a few dimensions. Is there a way to only show certiain vales of a dimension? For example, let's say that the cyclic group has 3 dimensions FIELD A, FIELD B, FIELD C. Users can cycle through these 3 filds in the pivot chart. FIELD A has 4 possible values: Value1, Value2, Valu3, UNKNOWN. I only want to show Value1, Value2, Valu3 in the pivot table when users click on FIELD A. Any idea how to do this?
When you create (or edit) a group you can click the Add expression button and create a calculated dimension for the group: if([FIELD A]<>'UNKNOWN',[FIELD A]). Give the expression a label and check the option Suppress When Value Is Null for the Group (on the Dimensions tab).
When you create (or edit) a group you can click the Add expression button and create a calculated dimension for the group: if([FIELD A]<>'UNKNOWN',[FIELD A]). Give the expression a label and check the option Suppress When Value Is Null for the Group (on the Dimensions tab).
