not show repeated

[#1]

Hello.   Is possible in a straight table only shows a repeated records? Xls attachment shows for you to see how I want to be the result  Thanks

[#2]

I forgot to mention that except column imports all columns are dimension

[its_anandrjs]

Hi,

As i understand you want to show only repeated records means desired result in excel file that you provide means whic reult you want export performance or desired result.

Rgds

Anand

[#4]

Hi Anand

I seek is the desired result table, I want the data that are equal to only show the first or last, I don´t know if this is possible

regards

[Anonymous · Accepted solution]

Why not use a Pivot table? And set the alignment of your dimension data to top (Presentation Tab)

That should get the result you want right?

[#6]

Hi Dennis

It is a good solution, But there is a column I want to remain hidden, but this is not a problem,the problem still exists the results of the expression to be repeated.

I think I will, PivotTable, in the absence of ideas is the best solution

Thanks

regards