4 Replies Latest reply on Sep 16, 2016 9:46 AM by shaheen.haque.1

# Avoid Repeating data in Graph and Table

Hi Guys,

I need your help here. I am really not sure how to describe it. I have a problem in Tableau Table, if you can see my attached data here the counts of Total Member is only dependent on Contract and the counts_1 is dependent on contract, region, category and metric.

Here what I want is that my total member should not be repeated it should be displayed just one time and remaining should be blank. This is creating more problem in my graph.

I created a dummy dataset and a dummy twbx file and have attached here. I know that this could be done by doing some manual change in the data but that is not the solution in my case. I have tried using average in graph but it is not giving me required result.

Please do let me know if I am not clear here. Its really very urgent, so your help is highly appreciated.

• ###### 1. Re: Avoid Repeating data in Graph and Table

Hi Shaheen, is this what you're looking for? I used a table calculation to make all but the first number in each Pane a null.

• ###### 2. Re: Avoid Repeating data in Graph and Table

hi Shaheen,

With Tableau there are (generally) lots of ways to solve a problem, and the best solution depends on the situation.

An alternative way, to using Index() would be to use a FIXED LoD. So this lets you aggregate some measure at a pre-defined level, and then we can wrap it in a further aggregate (again specified at the level of the FIXED LoD)...

So I've put in the calculated field

[Total Member - SR]

{FIXED [Contract]: MIN([Total Member])}

So I'm just taking the MIN of Total Members for each Contract, and then I bring this field on as a SUM (so summing the MINs...similar to how you'd do this in an Excel Pivot!!)

The other advantage of this method is that it is vizLoD independent (for completeness there are exceptions, but let's not confuse things!!), whereas for the index to work you'd need Contract in your Viz (which you can get around, but can make things a little complicated). The disadvantage is that there is a performance cost to FIXED LoD,  but unless your data is huge (or very complex) you'll barely notice.

Hopefully, this is what you were after, and makes sense, but if not please post back

• ###### 3. Re: Avoid Repeating data in Graph and Table

That was so helpful. Thank you so much

• ###### 4. Re: Avoid Repeating data in Graph and Table

Yes, this solves my table repetition problem. Thank you so much