Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a if condition in showing the review yr dimension in table.
And I want to create a default bookmark by input formula in search in table.
Since I use the if condition in dimension so I cannot use review_yr in the search directly.
How can I input the formula in search in the table so that I can search desired year using formula?
should create a table with multiple columns [Review_yr, Type, xxxxxxxx]
Then, input the formula according to the column like review_yr = '2017-2018' in review_yr column, type='HR' in type column.
When input all formula , save the bookmark
Try like:
=Review_Yr='2017-2018'
no, since there are other filters applying to the review_yr field.
It is not work when only review_yr=2017-2018
should create a table with multiple columns [Review_yr, Type, xxxxxxxx]
Then, input the formula according to the column like review_yr = '2017-2018' in review_yr column, type='HR' in type column.
When input all formula , save the bookmark