Slice formula

[Ing_Fred_Fiifi]

Please members I want to create a slice from a table base on linesman, faultman and maintenance man from a Designation column

[AleksiAlkio]

If you are looking for OR functionality, try IN([Designation],{“linesman”,“faultman”,“maintenance man”})

If AND is needed, use
AND(
[Designation]=“linesman”,
[Designation]=“faultman”,
[Designation]=“maintenance man”
)

[Ing_Fred_Fiifi]

thanks it work like magic

[AleksiAlkio]

Good to hear!