6 Replies Latest reply on May 6, 2016 9:14 AM by Mary Wike

# One Dimension, Multiple Measures  - Formatting Help

Hello All!

I have a report with one dimension (Metrics) that has multiple fields (Leads, % of Total, etc.). I'm hoping to get each field to have individual formatting.

I've attached the file and what I'm looking for as far as individual fields go:

1. Leads - Number
2. % of Total - Percentage (No decimals)
3. Sales \$ - Number
4. Units - Number
5. Win Rate - Percentage

Can I apply formatting on different fields? I've tried a calculation only to get a repeating number within the field for each Measure Value instead of its individual number.

If not, that's okay, I can make the decimals work - it'll just be a bit crowded. Or I rework the excel.

Thank you for any help!

Mary

• ###### 1. Re: One Dimension, Multiple Measures  - Formatting Help

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!

• ###### 2. Re: One Dimension, Multiple Measures  - Formatting Help

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.

• ###### 3. Re: One Dimension, Multiple Measures  - Formatting Help

Hi Marie See report attached.

I created a measure 'Metric Value' and then used this for custom calculation to do formatting.

Let me know if this works.

• ###### 4. Re: One Dimension, Multiple Measures  - Formatting Help

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.

• ###### 5. Re: One Dimension, Multiple Measures  - Formatting Help

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

• ###### 6. Re: One Dimension, Multiple Measures  - Formatting Help

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.

1 of 1 people found this helpful