Slice formula

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

IMG-20240123-WA0000.jpg

Solved Solved
0 3 60
1 ACCEPTED SOLUTION

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"
)

View solution in original post

3 REPLIES 3

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"
)

thanks it work like magic 

Good to hear!

Top Labels in this Space