Make a separate calc that is just a copy of your original field.
Format one with millions, and the other automatic.
On the large-data sheet, use the millions copy. On the small data sheet use the automatic copy.
But you can also format the same field on a sheet-by-sheet basis.
superstore -- format.twbx 990.8 KB
1 of 1 people found this helpful
You can format the sheet by selecting the field from the general format editor.
In the screen shot I have highlighted where you get that. In the toolbar on the left, in the upper right corner of that toolbar is the "Fields" pulldown. It's highlighted in the screenshot. Select your field, and you can format the display of that field for that sheet. It doesn't impact other sheets.
Mahika -- Does that take care of it for you?
Not Actually Joe But i got you what you are talking about..
I can add only one field because the numbers should change when Quick filters change by Users.If you have any idea please let me know.FYI its all in onesheet
Post a sample workbook that shows what you are trying to do. I can't picture what you are describing. If I have something hands-on, I can work with you on it. (If you post a workbook, specify the version of Tableau you are using so I can work on the same version with you.)