I have a request from my company to create a pivot table to do comparative analysis between two dates. Currently I am getting the data right but not able to shade in missing values under the data point. I posted some screenshots to help better understand the problem.
This is what my table looks like currently. I want every value under 100% to be shaded in gray.
This is my end goal. Any one have any ideas on how to accomplish this in qlik? Any insight would be very helpful