Here's a blog post that discusses a workaround to get Tableau to use two distinct number formats within a metric. It's a clever workaround, but has some limitations. Give it a look!
Hi Derek! Is this blog post assuming that my single metric is a measure? I'm trying to do this with a dimension and it won't let me complete the formula due to not being able to mix aggregate and non-aggregate comparisons.
Hi Khalid - Thanks for the help!
That's the route I went before and it works...for New Prospect, this is what happens when I implement:
All the numbers follow New Prospect's values. If I create another calculated field and insert it:
I feel so close haha, yet so far away! I'm concerned that I'll just have to redo my excel shell to be able to feed in and format it as I see fit.
I see your problem now.
Its because it doesn't allow you to use more than one
I think restructuring the excel is the best option
You just need to pivot the metrics across
1 of 1 people found this helpful
That was my biggest fear, luckily it's not anything impossible. Thank you for your help! It was at least helpful to learn some good calculated field lingo.