Skip to Content
s l
Nov 21, 2020 at 01:24 AM

Crystal Reports Question - Cross Tab


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.


capture.png (3.4 kB)