How to reference a field in table calculation that has not been selected in data but is in the filter

[garimagupta]

I have this data:
Filters:
issue resolution contains fixed, resolved, unresolved
Data:
issues severity(pivot) major minor critical
project name Issue count Issue count Issue count

Here is what I need:
A table calculation for % of unresolved issues= (issues with resolution = unresolved) /(issues with resolution in (resolved, done,unresolved))