Within Tableau, import $02$C$.$xlsx$.$

Create relationships between tables using the following diagram:

Create the following visuals with the same names:

$9.$ Invoices and Receivables

$10.$ Bad Debts

Invoices and Receivables :

Create two new calculated fields:

a$.$ Net Sales Revenue: Total Invoice Amount $-$ Total Adjustment Amount $($Use IFNULL function to eliminate any Null results$)$

b$.$ AR Balance: Total Invoice Amount $-$ Total Receipt Amount $-$ Total Adjustment Amount. Use IFNULL function

c$.$ Actual Write$-$off Percent: Total Adjustment Amount $/$ Total Invoice Amount.

Create a table that shows the months of January, and the following columns $($in this order$)$:

a$.$ Invoice Amount

b$.$ Adjustment Amount