# Conditional Formatting on CrossTab Column with Specific Name

**URL:** <https://forum.inductiveautomation.com/t/conditional-formatting-on-crosstab-column-with-specific-name/15895>\
**Category:** Ignition\
**Created:** [November 6, 2017, 3:26pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-on-crosstab-column-with-specific-name/15895 "2017-11-06T15:26:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmaynes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmaynes/32/6852_2.png) [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Post date:** [November 6, 2017, 3:26pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-on-crosstab-column-with-specific-name/15895/1 "2017-11-06T15:26:52Z")

</div>

I have a report with a crosstab table. A sample of the format of the data is as follows:

Stage,ModelNo,Type,Value  
1,MX01,Pass,10  
1,MX01,Fail,100  
1,MX01,Total,110  
1,MX01,Yield,0.89  
1,MX02,Pass,10  
1,MX02,Fail,100  
1,MX02,Total,110  
1,MX02,Yield,0.10  
2,MX01,Pass,10  
2,MX01,Fail,100  
2,MX01,Total,110  
2,MX01,Yield,0.45  
2,MX02,Pass,10  
2,MX02,Fail,100  
2,MX02,Total,110  
2,MX02,Yield,0.34

When the Yield column pops up, I want to format as a percentage. Is there a way to do this?

---

<div class="post-metadata">

**Author:** ![ray.crowder](https://avatars.discourse-cdn.com/v4/letter/r/e480ec/32.png) [@ray.crowder](https://forum.inductiveautomation.com/u/ray.crowder)\
**Post date:** [November 20, 2017, 9:28pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-on-crosstab-column-with-specific-name/15895/2 "2017-11-20T21:28:53Z")

</div>

I have not ever used the cross tab, so I took some assumptions on your setup. However, when you plug that dataKey in you can do a lot to manipulate the value. Try something like this `@dataSet.Value * 100@%`.

[https://docs.inductiveautomation.com/display/DOC79/Keychain+Expressions](https://docs.inductiveautomation.com/display/DOC79/Keychain+Expressions)

---

<div class="post-metadata">

**Author:** ![cmaynes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmaynes/32/6852_2.png) [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Post date:** [November 21, 2017, 1:07pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-on-crosstab-column-with-specific-name/15895/3 "2017-11-21T13:07:18Z")

</div>

Thank you, but that would not work. That would apply that formatting to all of the columns in the crosstab table and I need to apply that formatting to one column in particular.

---

<div class="post-metadata">

**Author:** ![cmaynes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmaynes/32/6852_2.png) [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Post date:** [November 21, 2017, 1:10pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-on-crosstab-column-with-specific-name/15895/4 "2017-11-21T13:10:34Z")

</div>

I solved my own problem:

I just converted all of the **values** to strings, filtered for the yield **Type** and then apply my formatting.

This is not an elegant solution, but it does work.