What is wrong with this
sum (dollor amount) where ((item)="shoe" or ( item)="sock")
It looks great to and does not work. I added the extra brackets as taught
SUM (if [item] ='shoe' or [item] = 'sock' then [dollar amount] end)
So basically, start by doing a row calculation to flag each row you want to aggregate, and then apply the SUM on the result.
Retrieving data ...