Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!!
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.
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.
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.