Feedback - Issues: 1. Grand Total (Rows) not showing 2. Column Headers ... Not Possible to change Column Width also the Auto_Size on Format Window dos not have any effect. Feedback: Requests 3. Facility to explode just one of the row categories (while leaving all others intact. At present the all data other than the drill-down selection are removed. This is facilitated by clicking on the + sign in Excel Power Pivot 4. Show Sub-Totals at the bottom of a Category rather than at the top ... or make it optional 5. Put a Display Units Control on Values (i.e. Thousands or Millions, just like the Chart Visuals) that ensures you do not have to write additional Measures to scale values and ensure the data fits on the screen 6. Manually adjust Column Widths
11 Comments
- Now the subtotals of the matrix are at the top respect of the data, please give the possibility to put them at the bottom. This could be very helpful in case of cascading subtotals (for example P&L)
- Also, if you adjust the size of a column with text wrap, every time you change something, like the title of the matrix or update the data, the column size is reset to default which is very annoying.
- I would add #7 - Allow sorting by clicking on a column header (same feature as in a table).
- Also, the default scroll after a cross-highlight or filter is half way down the table. The default scroll should be the top of the table. Also, why is it now such a rigmarole to submit feedback now - it's not an idea, I don't need help, I just want to report a bug please!
- Possibility to change the background for specific row headers, not all in one. Or add a new Matrix style which enables styles per level of detail.
- Would also like to be able to drill down from a matrix of summary data to detail data, perhaps in a pop up window.
- enable the user to display Row Totals, but without Row Subtotals
- Display units control on values - to show large numbers in '000 or Mill or Bill is needed
- An excel pivot table look a like matreix is needed. Drill down is not working efficiently.
5. Put a Display Units Control on Values (i.e. Thousands or Millions, just like the Chart Visuals) that ensures you do not have to write additional Measures to scale values and ensure the data fits on the screen
