Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK).
For the University of Manchester, what percent of the total publications were contributed in 2014?
A . 28.415%
B . 23.497%
C . 25.683%
D . 22.404%
Answer: D
Explanation:
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We’ll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let’s drag Country and Institution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf.
The following is our view: