
2. Re: Different number formatting and calculations in the same column
Gabriel de Leon Oct 17, 2016 4:40 PM (in response to Shinichiro Murakami)Yes and no.
It's actually how I've setup my workbook but doesn't solve the issue of changing number formats within the same column.

3. Re: Different number formatting and calculations in the same column
Ivan Young Oct 17, 2016 4:53 PM (in response to Gabriel de Leon)1 of 1 people found this helpfulAs far as the formatting you can take a look at this example. It has some of what you are looking for.
In terms of having different calculations, this may be possible but you'd probably be better off restructuring you data.

4. Re: Different number formatting and calculations in the same column
Gabriel de Leon Oct 17, 2016 5:10 PM (in response to Ivan Young)Thankfully, it's relatively early in the project and have the option of restructuring the data.
At the moment it's structured with a bunch of dimensions, with all results in a result column, and the same with targets.
Any suggestions?
Also any chance for a Tableau 9 version of the workbook you published?

5. Re: Different number formatting and calculations in the same column
Srinidhi Narayan Oct 17, 2016 6:39 PM (in response to Gabriel de Leon)The easiest method is to duplicate the measure and create a copy (or many copies). Tableau is smart enough to source the measures from the same original column. You can then use those measures in the same viz, but treat them differently. You will have to name them uniquely, however, to be able to identify the pills.

6. Re: Different number formatting and calculations in the same column
Shinichiro Murakami Oct 17, 2016 10:38 PM (in response to Gabriel de Leon)1 of 1 people found this helpfulQuite troublesome, but here is my approach.
need to create 3 x 3 different fields.
Then put them to same label card with conditions.
[Result $]
if [Sub Category]="abc" then [Result]end
[Result %]
if [Sub Category]="def" then [Result] end
[Result abs]
if [Sub Category]="jkl" or [Sub Category]="ghi" then [Result] end
[Target $]
if [Sub Category]="abc" then [Target] end
[Target %]
if [Sub Category]="def" then [Target] end
[Target abs]
if [Sub Category]="jkl" or [Sub Category]="ghi" then [Target] end
[Result $ delta]
if [Sub Category]="def" then [Result][Target] end
[Result % delta]
if [Sub Category]="def" then [Result][Target] end
[Result abs]
if [Sub Category]="jkl" or [Sub Category]="ghi" then [Result][Target] end
Change the default format for each field
Same thing for Target and Results Target
Thanks,
Shin