0

I have a chart with a calculated dimension

it contains 4 possible values A, B, C, or D

however in my bar chart i only want it to contain B and C

I have tried:

=MATCH(CATEGORY, 'B','C',)

But this just numbers them.

Matt
  • 14,906
  • 27
  • 99
  • 149

1 Answers1

0

Using the IF condition this can be achieved with:

if(MATCH(CATEGORY, 'B','C'),CATEGORY)
Matt
  • 14,906
  • 27
  • 99
  • 149
  • Its information that helped me so I want it to be helpful to everyone on Stackoverflow – Matt Jun 09 '19 at 09:03