Change data source structure with Pivot. Pivot Data from Columns to Rows
Create calculated field
if attr([Pivot field names])="F2" then ZN(sum([F17]))
elseif attr([Pivot field names])="F3" then -ZN(sum([F17])) end
put each pills to respective fields.
start_end_SM_9.1.twbx 136.6 KB