Minute 13:00 — 14:00

this is going to select all of our data for us so it’s really easy and we’re going to hit okay and so now we have all of our pivot down i don’t need to pull it out that far that was way too far and now we have all of our pivot table information over here and so that should make it really easy to you know actually build out so what we’re going to do is start selecting what columns and what data we actually want to work with so the first one that we are going to build out is a dashboard that is basically looking at the average income of somebody who either bought or did not buy a bike so we need in this one we’re going to need their income that’s definitely going to be a value right here but we want to break it out by male and female so let’s look at their gender i’m going to pull that down into the rows so this is basically a sum and now let’s look at let’s make this an average so i just went to the

i clicked right here i went to the value field settings and we’re just gonna do