Have you tried dividing the view into two separate sheets with fewer than sixteen fields on the Columns shelf on each sheet?
Then create a dashboard and place both sheets onto the dashboard next to one another.
The limit in one sheet is currently 16.
To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: Display More than 16 Text Columns in a Crosstab.
I must say that 16 is currently pretty large and it would be tough to visualize... but that's up to you!
1 of 1 people found this helpful
Although the solution is not advisable but still you can try.
Unpackage the workbook.
Right click and open with either notepad or notepad++.
<format attr='row-levels' value='16' />
<format attr='row-horiz-levels' value='16' />
<format attr='col-levels' value='16' />
change the numbers to 30 and then save the workbook.
See if it works.
Thanks ankit this is helpful and I did try out this approach as well. But the problem here is the scroll bar don't appear and the value column moved toward right goes missing
I am sure you must have faced this issue as well.
Can you share your workbook with mock data?
Create sheet 1 with 16 columns
create sheet 2 with the remaining columns
on the dashboard, place the 2 sheets besides each other
This will lead of data mismatch
1. when you do filter
2. Scroll will not be in sync
If the granularity of both sheets is same, filter shouldn't create any issue. Send mock data if possible