COUNT within slice

[jonbowles84]

Hi,

I have tried for hours for the simplest formula!

I have a slice called "Within Range" and in that I have a text column called status, I want to count the number of times the value "X" or "Y" appear within the slice in a virtual column of a summary table...

Sorry for being so simple!!

[TeeSee1 · Accepted solution]

Try this...

COUNT(FILTER("ya slice", IN([status], LIST("X","Y"))

[jonbowles84]

@TeeSee1 to the rescue once again! Thankyou!