Handling no data in row / column
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
What if we wanted to show the sum of financial aid received for IL students in each Primary Focus, showing all Primary Focuses (even if one has no financial aid)?
We'd place the Primary Focus field in the "Rows" section and the "Financial Aid" field in the "Values" section...
...and then filter based off of the State field, only selecting IL.
Oh no! No IL students are involved in the "Python" Primary Focus! How devastating!
We must fix this and still show the "Python" Primary Focus, because the question is asking us to show a Primary Focus even if it has no financial aid. How, though?
Simply click the "i" icon next to the Primary Focus field in "Rows" and check the box saying "Show items with no data"!
Now we're able to see the "Python" Primary Focus, despite it not having any financial aid data.
If you need to see rows without data, just click the information button next to the field and check the box saying "Show items with no data".