4 Replies Latest reply on Jan 16, 2019 5:19 AM by Zhouyi Zhang

Conditional formating on table with several metrics

William Wayne Jan 11, 2019 4:59 AM

Hello friends,

I have a simple table which consists of two measures + two quick calculations :

- I would like to apply conditional formating only on the two quick calc showing the difference. Green when >0 , red when <0

- So far I have not managed to apply the coloring only to specific rows, neither have I managed to separate the two quick calc : it appears I only can choose one quick calc (either CA or QTY) to create a color rule on

Thanks for any help you can provide,

Cheers,

export.twbx 295.5 KB

1. Re: Conditional formating on table with several metrics

Zhouyi Zhang Jan 11, 2019 5:23 AM (in response to William Wayne)
Hi, William

Please find my solution attached, below is the screenshot for your reference.
I use min(1) as place holder for your 4 measures, the detail steps of how to create the place holder I have explain in the below thread.

Hope this helps

ZZ

export_v10.5.twbx 311.0 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Conditional formating on table with several metrics

Zhouyi Zhang Jan 11, 2019 5:28 AM (in response to William Wayne)

And another way probly works for you as well

ZZ
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: Conditional formating on table with several metrics

William Wayne Jan 14, 2019 9:51 AM (in response to Zhouyi Zhang)

Hey ZZ,

Many thanks that works perfectly.

WW
Like Show 0 Likes(0)

Actions
4. Re: Conditional formating on table with several metrics

Zhouyi Zhang Jan 16, 2019 5:19 AM (in response to William Wayne)

No worries, I am glad to help
ZZ
Like Show 0 Likes(0)

Actions