Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking to filter two sets of fields in a pie chart.
1.Assembly/Component/SMD - Only to show Assembly
2. Assembler - Only to show Carol
I want both of these to measure the 'Units' field. I've tried the below but doesn't seem to be working as expected.
=If(match([Assembly/Component/SMD],'Assembly')
=If(match([Assembler],'Carol')
try this
=If(match([Assembly/Component/SMD],'Assembly') and match([Assembler],'Carol'),'Asmbly','Carol')
try this
=If(match([Assembly/Component/SMD],'Assembly') and match([Assembler],'Carol'),'Asmbly','Carol')
Hi - thanks that does seem to be working. I'd like to filter the count as well. Below doesn't seem to be working as expected.
=Count( {<[Unit] = {"=[Unit] <> 'Carol'"} >}[Unit])
May be this
=Count( {<[Unit]- = {'Carol'} >}[Unit])