Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display only dimension values without expression

Hello,

Is it possible to show only dimension values without any expression.

I have one ad-hoc report,I wants that even expression is not selected,it should display only dimension values.

Thanks in advance !!!


1 Solution

Accepted Solutions
Nicole-Smith

You'll need a "dummy" expression.  Just use '' or 1 and all dimensions will display.  If you use the '', it will look as if the column is empty (if you're using a pivot table) or you can hide the column if you're using a straight table.

View solution in original post

2 Replies
Nicole-Smith

You'll need a "dummy" expression.  Just use '' or 1 and all dimensions will display.  If you use the '', it will look as if the column is empty (if you're using a pivot table) or you can hide the column if you're using a straight table.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Is a Straight Table without any expressions a Table Box?  Rather than picking the Chart option from the New Sheet Object menu pick Table Box and you are away.

If there is a reason why it needs to be a chart (more control over cell colours etc.) you can do exactly as Nicole suggests and have an expression of 1 and hide the column on the Presentation tab.