Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team
I have a straight table which is having 25 rows
can we delete certain rows in the straight table, how can we do
regards
Pnreddy
Thank You
Thank You
Updated now check
Write dimension like
If( Not Match(A,'a4'),A) in the dimension
and select Suppress when value is Null
Like everyone else says, do it by
- not loading it in the data in the first place (where clauses, match(), if() and so on)
- by making an expression in the straight table resulting in the row(s) not being displayed
- by doing selections in the straight table.
I think the best solution for you depends on WHY you want to delete/hide the row(s), cause I'm not fully understanding your requirement. Should it be present in the data at all, is it during navigation/analysis you want to disregard the row etc. ![]()
/Nicolai
i have one more question
can we foramat the straight table as below

Go to style tab and select from Current Style
Hi
What formatting are you looking for specifically? ![]()
- the bold headers
- the separated "$ 105" values
- the conditional coloring of the rows
- no row borders?
Remember besides style, you get more options for formatting when design grid is activated, e.g. custom format cell when right clicking the cells. ![]()