Hello I have the below cross tab which looks like below:
There is a different formula to calculate the SLS which basically looks like below:
COALESCE(SUM(CASE WHEN (((field 1) = 'SLS')) AND (((field 2) = '1')) THEN Field 3 ELSE NULL END), 0)
Is there a way to add this sql in the cross tab under the SLS column??
I am confused and I am not sure what needs to be done. Any help would be appreciated.