Create Metric With Excel Data

Create a high standard metric showing the below. Show all pivot table fields and metrics/charts used in separate tabs if needed. .

How many total for each Creator ?

For each Creator how many have DEFAULT DOCUMENT TITLE in Title field out of the total they have done.

For each Creator how many have blank/null  in Comments (b2Comments) field out of the total they have done

Translate the Creator id”field into a real name. Creator ID and corresponding name can be found in second tab.  Maybe write a query that will pull the name from the second tab(creator name), just incase i add new Creator ID. So the metric should show Creator name instead of ID.

In the future , I will want to do the same thing multiple times by just copy and paste details into the excel sheet with headings remaining the same.  Therefore, I am looking for a repeatable way to do this so all i have to do is paste new data and i can spit out or refresh  the metric quickly.

Excel file will be attached

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"