Revise the visual table to add the periodic target number

[duncan]

Hello @Junny , welcome to the Quicksight community!

have you tried the solution provided here?:

Dynamically change the seasonality target value

I have the below table. For each of the customer we have multiple SKU sales value (Product A sales values, Product B sales value etc.). Based on the monthly target, each product sales value field for each customer will show as green, yellow, or red. Since I have more than two columns, I have used a table with conditional formatting, instead of heat map. In addition, I am maintaining a calculated field to set the target value. [Screenshot 2023-02-10 at 10.27.47 AM] Now we have to manually upda…