Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with a few dimensions and expressions. Would it be possible to display a space (empty row) between each individual dimension values as shown in the attached image.
Sort of. Create a pivot table. Change your expressions to something like =if(dimensionality()=1, ...original_expression, ''). Enable the option Always Fully Expanded. Enable Partial sums for Dimension 1 and set the Label for Totals to a single space.
Sort of. Create a pivot table. Change your expressions to something like =if(dimensionality()=1, ...original_expression, ''). Enable the option Always Fully Expanded. Enable Partial sums for Dimension 1 and set the Label for Totals to a single space.