$29.$ ?Based on the data sheet from sheet $6,$ ?you have been asked to create a dashboard with a pivot table. The requestor wants to know the total spent per month by each account. You have been provided the following information $($ sheets $4,5,$ ?and $6$ ?are attached $)$

Hospital September

A $ $80,570\mathrm{.}13$

B $ $2,269\mathrm{.}23$

C $ $7,335\mathrm{.}20$

a $.$ ?Values $=$ ?hospital, rows $=$ ?date

b $.$ ?Rows $=$ ?product description, values $=$ ?total paid, columns $=$ ?date

c $.$ ?Rows $=$ ?hospital, values $=$ ?total paid, columns $=$ ?date

d $.$ ?Rows $=$ ?hospital, values $=$ ?purchase quantity, columns $=$ ?date