PDP is currently limited and does not allow users to permission based on a condition in a given column/row.
Current State Example: The group that runs the farmers market can see the revenue that each vendor generated. Each vendor should be able to see the quantity sold for all farmers market sales, but they're not entitled to see revenue or which vendors benefited from a particular sale, except their own. Each vendor is allowed to see their own quantity sold and the total sold quantity for any items they sale.
There needs to be a way to apply conditional PDP for individual intersection masking. Users should be allowed to add SQL statements that cross-reference row level governance. Sara can only see the value in the column Vendor, Unit Price, and Revenue Generated if a certain criteria is met within the row of the vendor column. Simply filtering out the rows doesn't work for Sara because she needs to see the total market possible at the farmers market to aid in her production decisions for the upcoming harvest.
