Hide Row names from view?

[Anonymous]

Hi

I was hoping someone could help me to hide names in a row without losing the data

For example I only want to show "Martin" but not lose the rank or result

example table:

Name     Rank      Result

Martin     1            80%

James     2            76%

Paul        3            75%

I am hoping the result will look like the below

Name     Rank      Result

Martin     1            80%

               2            76%

               3            75%

Thank you in advance

[Miguel_Angel_Baeyens]

The solutions by Stefan will likely help:

Get max cell value of all rows and columns

[olivierrobin]

hello

you can code an expression to display/hide value on condition

-> but what is the condition ?

suppose it's rank, you could write in expression

if(Rank=1,Name,' ')

[Anonymous]

it would be based on the name

There are about 6 tables where the rank would be different for each person

Thank you

[Anonymous]

Ahhh school boy error

If I select the name it filters the results anyway making "Martin" rank 1 in all tables

[olivierrobin]

but the goal is not to select ?

if it is based on a list of names, and this list is stored somewhere, you can left join this list with your data, and create a flag

in your graph, you write a condition based on the value of this flag

[Anonymous]

No not really

the names in the example represent a manufacturer - I have grouped the companys into the main parent group and used a selection box to limit the results to the top 5

but I don't want to show all results to all companys so to add in an additional layer to hide 4 of the 5 would be the preferred option (more of a view filter than an actual data one)

I hope this makes sense

[olivierrobin]

if you can write an if condition, you can hide them

[Anonymous]

Hi Johnson,

In Expression you can check Firstsortedvalue(Name) using this you will get only selected name other fields will come as usual.

Thanks Regards,

Ramesh.P

[Anonymous]

I would tell you the procedure which i have followed for resolving your query

Step 1: In the data manager edit the sheet where your data is present

Step 2: click on select nulls and select paul and James and set them as 'set nulls'

Step 3: when you create an infographic you get the visualization the way you mentioned in your query.

Hope this helps