in the data connection window,
first select those 3 columns and pivot as shown here
then create a calculation Amount to get the amount as a single column:
if [Pivot Field Names]= 'Accepted' then [Accepted Amount]
ELSEIF [Pivot Field Names]='Rejected' then [Rejected Amount]
ELSEIF [Pivot Field Names]='Pending' then [Pending Amount]
see attached workbook for details.
sample.twbx 13.3 KB