Hello,
I have a problem and I am not so sure it has a answer, but if you know something please help!
table 1 | Coolers | Department | % Share | |
| | 88,5% | |
Refrigerator | invaded | 88,5% | |
Refrigerator | 70% stock | 88,5% | |
| | | | | | | | | |
table2: what I have now | Coolers | invaded | 70% stock | % Share | |
Refrigerator | "red cross" | "red cross" | 88,5% | |
invaded | if(Department='invaded','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png') | |
70% stock | if(Department='70% stock','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png') | |
| | | | | | | | |
table 2: waht I want | What I want to see is : | |
Coolers | invaded | 70% stock | % Share | |
Refrigerator | "green check" | "green check" | 88,5% | |
| | | | | | | | | |
If I had on table 2 the department included in the dimensions it would be like this | |
Coolers | department | invaded | 70% stock | % Share | |
Refrigerator | invaded | "green check" | "red cross" | 88,5% | |
Refrigerator | 70% stock | "red cross" | "green check" | 88,5% | |
This is correct, but I want to see it in just one line both with green check | |
| | | | | | | | | |
Going back to table 2 : | |
Coolers | invaded | 70% stock | % Share | |
Refrigerator | "red cross" | "red cross" | 88,5% | |
If I introduce on the side a Department filter and select one of the two it will appear its green check | |
filter department: invaded selected | |
Coolers | invaded | 70% stock | % Share | |
Refrigerator | "green check" | "red cross" | 88,5% | |
Again what I expect is to see both on green since both are included in the coolers refrigerator type. | |