Search code examples
tableau-api

Tableau - table formatting, stop merging/centring

I can't figure out an option I'm sure Tableau has.

Its easier to explain with visually so I'll show you what my table looks like and what I'd like it to look like (at least when I export to excel).

Looks like:

Date  Group   
1st     a           
        b           
        c   
2nd     a           
        b           
        c

What I would like:

Date Group    
1st    a    
1st    b    
1st    c    
2nd    a     
2nd    b    
2nd    c

So I'd like no merged or blank values as at the moment when I export to Excel I have to unmerge and then manually fill the blanks which for large sets of data is a nightmare.

Solution

  • There are a couple of ways you can do this:

    1. Put the row's distinct value (aka - deepest level of detail) in your first column.
    2. Use the View Data feature under Analysis in the Menu bar (also found in other places).