1 of 1 people found this helpful
Steps should be like below
If [Age] column is Measure then we can use Bins.
Bins: Right click on that Measure Column, click on "Bins".
Select Analysis > Create Calculated Field.
In the Calculated Field dialog box, complete the following steps.
- For Name, type Age Groups.
- In the Formula box, build the following formula, which defines several age groups:
[Age] < 21 THEN "Under 21"
[Age] <= 32 THEN "21-32"
[Age] <= 42 THEN "33-42"
[Age] <= 52 THEN "43-52"
[Age] <= 64 THEN "53-64"
- Confirm that the status message indicates that the formula is valid, and then click OK.
Create a view with the variable bin field
From the Measures pane, drag Number of Records to the Rows shelf.
From the Dimensions pane, drag the new Age Groups field to the Columns shelf.
All of the records are split into the six bins that you defined in the calculated field.
Note: To sort the bins, right-click Age Groups in the Columns shelf, and click Sort.
If [Age] column is Dimension then we can create a calculated field.
Please mark the answer if helpful
Thank you Don and Ritesh. That worked perfectly.