Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I think you're asking for this?
Properties -> Presentation -> Always Fully Expanded
I think you're asking for this?
Properties -> Presentation -> Always Fully Expanded
Brilliant, thank you !!!!