Hello Experts,
I have a text table that contains pricing data by location, supplier for each product. I need to highlight all the suppliers when their current day price (CD Price) is lower than PFC supplier?
I've attached my workbook and the desired output.
Thanks in advance.
2 answers
Hi,
Attached workbook with solution.
Create a Fixed Calculation
{Fixed [Terminal],[Move Date],[Product]:SUM(
IF [Supplier] = "PFC" THEN [CD Price] END)}
Create a calculation for Row Color
SUM([Fixed CD Price])>SUM([CD Price])
Add Row Color to color shelf and format marks
Thanks!
