Hello,
I Want to Have filter Formula to Select Selected Rows for Slices
Here is Formula what i am Using in Row Filter
OR([Key Column]=“Printing”, AND(OR([Status] =“N” ,[Status]=“C”),Contains([Type],“Ptg.”),NOT(CONTAINS([Key Column],“Direct”))))
Problem Here is that it Pick Up Double Row Having Same Ciretria
I want To Have Only First Matching Row
I Want to Add Filter for Col2 to Pick up Oldest Entry
is There is any Way to Achive This
Thanks
Solved! Go to Solution.
Try the following as your slice’s row filter expression, replacing table
(1x) with the name of the table:
(
[_ROWNUMBER]
= MIN(
SELECT(
table[_ROWNUMBER],
OR(
([Key Column] = “Printing”),
AND(
OR(
([Status] = “N”),
([Status] = “C”)
),
CONTAINS(
[Type],
“Ptg.”
),
NOT(
CONTAINS(
[Key Column],
“Direct”
)
)
)
)
)
)
)
Does it work using ORDERBY() and TOP()?
Try the following as your slice’s row filter expression, replacing table
(1x) with the name of the table:
(
[_ROWNUMBER]
= MIN(
SELECT(
table[_ROWNUMBER],
OR(
([Key Column] = “Printing”),
AND(
OR(
([Status] = “N”),
([Status] = “C”)
),
CONTAINS(
[Type],
“Ptg.”
),
NOT(
CONTAINS(
[Key Column],
“Direct”
)
)
)
)
)
)
)
Thanks @Steve Your Formula Worked
User | Count |
---|---|
45 | |
27 | |
27 | |
21 | |
13 |