And for more transparent look we should remove totals from pivot table report. Next, let’s drag AGE dimension into Rows. This action will create implicit measure Count of SMOKER. In the Columns field we should drag the dimension SMOKER, and we will repeat this by dragging it to the Value field. Let’s select the data range and then create a pivot table in the same worksheet. In the first column there are years of respondents, and in the second answer to the question whether respondent is a smoker or not (YES or NO). In one simple case, where we research the age of the respondents and the answer to the question whether they are smokers or not, you will see how the groups (bins) are made and how can we later use them to create beautiful charts. When we create a pivot table report, based on statistical data, it’s sometimes convenient to group them into bins so that we can analyze them more easily.
0 kommentar(er)
