$28.$ Based on the data from sheet $6,$ you have been asked to create a dashboard with a pivot table. The requestor wants to know the total spend per month for hospital $$A$$ on $340$B$,$ WAC, and GPO. You have provided the following information:

$340$B $$2,997\mathrm{.}02$

GPO $$73,709\mathrm{.}85$

WAC $$3,863\mathrm{.}26$

a$.$ Filters $=$ hospital, Values $=$ total paid, Columns $=$ Date

b$.$ Filters $=$ hospital, Rows $=$ type, Columns $=$ date, Values $=$ total paid

c$.$ Filters $=$ type, Rows $=$ hospital, Columns $=$ date

d$.$ Values $=$ type, Rows $=$ hospital, Columns $=$ date

e$.$ Rows $=$ type, Filters $=$ date, Columns $=$ Hospital