Hi community,
I have a table visual in a report I am working on showing target values and actual values for different categories and locations. So for the target table where I have the data for targets per location and category I have:
| Location | Category | Lines | Target |
| Sweden | Drilling | 1 | 2 |
| Sweden | Milling | 2 | 2 |
| Sweden | Turning | 2 | 6 |
| Denmark | Drilling | 2 | 4 |
| Denmark | Milling | 1 | 1 |
| Denmark | Turning | 2 | 6 |
And from a database I get the actual figures as in this example:
| Location | Category | Month | Actual |
| Sweden | Drilling | aug | 2 |
| Sweden | Milling | aug | 8 |
| Sweden | Turning | aug | 11 |
| Denmark | Drilling | aug | 4 |
| Denmark | Milling | sep | 7 |
| | | | |
So the database will keep building of course with more data for every month. I get the data in the visual table all well but when I filter per month I want the "actual" column in the visual to turn red if above target and green if below or equal to target. The resulting table should look like this when filtered:
| Location | Category | month | Target | Actual |
| Sweden | Drilling | aug | 2 | 2 |
| Sweden | Milling | aug | 2 | 8 |
| Sweden | Turning | aug | 6 | 11 |
| Denmark | Drilling | aug | 4 | 4 |
| | | | | |
So the numbers are all correct but how to make a "dynamic" calculation like this for, I am assuming, conditional formatting? I am stuck to how to achieve this and any help would be much appreciated.
Regards,
Maud
