There might be cases when you are required to show more columns in the columns shelf. By default it will show us 6 columns and if you keep on adding more columns then it will automatically show us comma separated values as you add as shown below:
As soon as I added the seventh column in the shelf it gives me comma separated as shown in the above. So In order to make sure it shows each column individually we need to make some settings to allow any number of columns as per the requirement but still remember there is a hard limit for this.
Go to Analysis >> Table Layout >> Advanced..
then it will open Table Options window as shown below:
Here as you see there is only 6 in the rows section as and when you add 7th column the first two columns are showing as one with comma separated. But the moment you increase the value here and say "Apply" it will be considered as individual columns as below.
No comments:
Post a Comment