9 Replies Latest reply on Jun 12, 2018 5:37 AM by Diana Lujza Toth

Copy crosstab with decimals

Diana Lujza Toth Jun 12, 2018 3:22 AM

hi I am not a Tableau expert and I am sure someone will have a quick answer for my problem. I have a database and a calculated field (average order value). Format is set to 2 decimals.

When I go to Worksheet - copy - crosstab, and paste it to excel, I can not see ANY decimals. For 846,71 USD I can only see 846. Can someone help me?

Export to excel does not work because it is extremely slow and I have to send the data to a user without Tableau.

thank you.

1. Re: Copy crosstab with decimals

Tushar More Jun 12, 2018 3:31 AM (in response to Diana Lujza Toth)

Hi,

Try setting default number format.

Please try this right click your measure in the data> select number format.

Set decimal places.

~Tushar
Like Show 0 Likes(0)

Actions
2. Re: Copy crosstab with decimals

sudheer.kumar.5 Jun 12, 2018 3:32 AM (in response to Diana Lujza Toth)

Hello Diana,

Can you try to replicate the issue you are facing with some sample data? .TWBX file is helpful.

I have tried to replicate the issue and below is the output.

Am I missing something?

S
Like Show 0 Likes(0)

Actions
3. Re: Copy crosstab with decimals

Diana Lujza Toth Jun 12, 2018 3:52 AM (in response to Tushar More)

I tried but it does not work. I am going to attach an example workbook.
Like Show 0 Likes(0)

Actions
4. Re: Copy crosstab with decimals

Diana Lujza Toth Jun 12, 2018 4:06 AM (in response to sudheer.kumar.5)
Hi!
I tried it with the attached example workbook and it still does not work.
1) if I set the number to currency with 2 decimals, it looks like this in TDE:

then I go to copy-crosstab it puts the decimals in a separate column in Excel:

If I set the number to default, it uses simple numbers without decimals. In excel it loses all decimals (and this happens if I set it to currency/number without decimals):

Lujza_example.twbx 26.1 KB
Like Show 0 Likes(0)

Actions
5. Re: Copy crosstab with decimals

Tushar More Jun 12, 2018 4:47 AM (in response to Diana Lujza Toth)

Hi Lujza,

This is what I have in Tableau

I copied the data to excel and I got following.

It's not putting decimal in other column.

`Tushar
Like Show 0 Likes(0)

Actions
6. Re: Copy crosstab with decimals

Diana Lujza Toth Jun 12, 2018 5:13 AM (in response to Tushar More)

...then I have some other problems which is not related to Tableau. I tried a few times since then, and got the same results, numbers without decimals or decimals in separate column.
thank you for trying to help me!
Like Show 0 Likes(0)

Actions
7. Re: Copy crosstab with decimals

sudheer.kumar.5 Jun 12, 2018 5:18 AM (in response to Diana Lujza Toth)

Hello Lujza,

Are you using Worksheet -> Export -> Crosstab to Excel option?

The result is below:
If you use Ctrl + A and paste in Excel will give you a different result.

S
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
8. Re: Copy crosstab with decimals

Mavis Liu Jun 12, 2018 5:28 AM (in response to Diana Lujza Toth)

Hi Diana,

Your values are being split into two columns because you had set your text to columns to be split:

Thanks,

Mavis
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
9. Re: Copy crosstab with decimals

Diana Lujza Toth Jun 12, 2018 5:37 AM (in response to sudheer.kumar.5)

if I use export, the numbers are ok, but this is a big database and exporting is very slow.
Unfortunately I have to send these data to a colleague regularly and I wanted this to do with copy crosstab which is really quick.
Anyway, I tried it again and it works. thank you.
Like Show 0 Likes(0)

Actions