Forum Discussion
Formatting matrix with same rows but different measures
Hello, I have some formatting questions about matrixes.
i have these two matrixes that i would like to work somewhat in sync with each other. one is showing when inventory will be available and the other one is showing the weeks until that date. i am wondering some best practices/tips on how to format both tables so they change with each other when someone selects a category group or scrolls down the lists. I dont think its possible to have two seperate measures in the same matrix without this happening
any help would be appreciated.
1 Reply
Sorry, I'm not entirely clear on what exactly you're asking here but to me it seems like it would be best formatted if you applied conditional formatting (background or font colour) on the TOTAL Weeks measure. You can go into Conditional Formatting > Background colour > Advanced Controls > Based on field > [Negativedatecolor]. That should simplify that last table and hopefully get them to work together how you want them to.
