Forum Discussion
Table / Matrix Visual Customization for better visiblity
Hi GanesaMoorthyGM ,
In this case you need to change the layout of your matrix and on the layout chose tabular mode:
You can handle subtotals in the options and you can define to what level you need them you have it for rows and for columns:
You can select each of the levels and then turn it off has needed.
Hi GanesaMoorthyGM ,
You need to place the Cluster in the columns of the matrix this will make the levels has you need so you will get the location and years on the rows and the measure will be split by the different columns.
Hi MFelix , Thank You for you r resonse. I already tried this is matrix but still my requirement is not matched.
So you can see here that Month and FiscalYearcode are within Location but i want them like this
Things i did in my visual after following your insights.
Hi GanesaMoorthyGM ,
In this case you need to change the layout of your matrix and on the layout chose tabular mode:
Yep! MFelix . It worked for me as well. Thank You for Your Insight.
Hi Mr MFelix . I need one more help from you.
You can see here it is showing subtotal within like april and its subtotal so this makes the readability and visibility confusion to the user. Is there anyway to remove that subtotal?
You can handle subtotals in the options and you can define to what level you need them you have it for rows and for columns:
You can select each of the levels and then turn it off has needed.