see the attached
Tableau will bring in the number in the format provided by the source
you can control the output format as shown below
I just took the sum(sales) from superstore and formated the viz 3 ways - in the original - in thousands - and in millions
a box will open and you can customize the format
thins is what the 3 values look like
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
number formats.twbx 1.2 MB
Can u clarify what do you mean by downloading?..User wants to see unformatted number when they download to Excel/PDF
I see - misinterpreted the need here
I don't have a solution for you
So here is a bit more explanation on what is exactly happening:
Users access a specific URL to reach the workbook on the in-house tableau server. Then they select a chart on a dashboard and click download ->crosstab. The hence downloaded crosstab in excel shows the number formatting applied on the chart i.e. $70M.
However the users want that the crosstab shows numbers unformatted i.e. 70000000.00 .
We do know that when users select the Download->Data option the numbers are unformatted, but the users find crosstab more efficient for their use.
What I can suggest you to make a copy of your column without any formatting and uncheck the Show Header for this duplicate column. This was this column won't be visible when viewing through tableau server. When you download to cross you can have both the columns showing formatted and unformatted column $7M ,70000000.00
Otherwise I don't see a solution for this.
If this assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Well, thanks for the replies but since it is the end users who download the data in crosstab format, it wont be useful to have two same columns with different format.