2 Replies Latest reply: Dec 28, 2011 12:00 PM by Marita Ellmers RSS

    Pivot Table with more than one dimension

    Marita Ellmers

      In a pivot table with several dimensions it is automatically possible to show different levels of detail by clicking on the + or - signs.

       

      Is it possible to deactivate this option?

       

      Our data would always need to be visualised showing the highest level of detail, subtotals or sums don't make any sense in this case.

       

      Unfortunately using a standard table is not the solution (Crosstable was used to load the data and pivot to switch from rows to columns). Also tried to utilize just one dimension in combination with several formulas instead of several dimensions plus one formula but then the data is not shown correctly.

       

      Are there any alternatives? Thank you very much in advance!