Tableau Online: How do I get rid of the automatically displayed 'Abc' column when adding a field to Rows?

487 Views Asked by At

I'm trying to put together an Excel style report on Tableau where the rows have an id and some aggregated fields.

Eg.

id | sum(revenue) | sum(hours)
1.       100.           10 
2.       200.           20
3        399.           40

However, whether I have just the ids or include the aggregated fields, there is an extra column. It has no header and displays 'Abc' in each row.

Eg.

id | sum( revenue) | sum(hours) |
1.       100.           10        'Abc'
2.       200.           20        'Abc'
3.       399.           40        'Abc'

What is this extra column and is there any way to hide it? Thank you.

Screenshot:

enter image description here

2

There are 2 best solutions below

0
On BEST ANSWER

You can drag your measure into the text shelf and Ref Id to Rows. This will give you a text table.

enter image description here

Or you can drag your measure to Columns for a chart.

enter image description here

If you need to just show your Ref Id with no measure, you can hover over the far-right edge of the Abc area and when the double arrow icon shows, you can drag text area to the left to hide it.

enter image description here

0
On

You can hide by adding (" ") to your text column @Marks like shown in the picture Remove ABC