Forum Discussion
jazzhanya
8 years agoFrequent Visitor
Display KPI Light Last Month Status in Report Table
Hi everyone, In my data, I have one column called "Year/Month". I want the last table column (marked in red) shows the last "Year-Month" status of Overall RAG color (makred in blue) with the foll...
jazzhanya
8 years agoFrequent Visitor
Any answer / good tips please..?
v-jiascu-msft
8 years agoMicrosoft Employee
Hi jazzhanya,
As we can see from the first image, the last six columns are the same. So what's the logic here? Can you share the formula you used? For example, [Sales] >= 100, Red (face 1); [Sales] < 100, Green (face 2).
Share some data if you can.
Best Regards,
Dale