How to add expression in straight table without duplicates?

[#1]

Hi,

I have a column CustomerId with duplicates. I need to add this column as expression in straight table without duplicates. can anyone please suggest how to add expression without duplicates.

Thanks.

[mjayachandran]

Hi Amelia,

Do not send to excel rather, just right click on the pivot table --> Copy to Clipboard -- FullTable and

Paste it in Excel.

[#3]

Hi,

It's possible.

On the list box,  click the right mouse button, then copy into clipboard.

And then copy to Excel . 

Sorry for Korean character.

See the image below.

WanKi,