Chart (Pivot)Table Dimension Vs. Expression

[#1]

Hi all,

I really want to  know why it is not possible to display different Expressions in one column that belong to the same dimension in a Chart Table

I have something like this:

BusinessUnit	OrderNumber
1-2-3	1111
1-2-5	2222
1-2-3	3333
5-5-5	1234
1-2-3	5555

And I want to display it like this:

BusinessUnit	OrderNumber
	1111
1-2-3	3333
	5555
1-2-5	2222
5-5-5	1234

BusinessUnit is my dimension and OrderNumber is my expression.

So maybe I havent understand the difference between dimension and Expression correctly.

If I do this in a TableBox it is nearly working. Because then I get this:

BusinessUnit	OrderNumber
1-2-3	1111
1-2-3	3333
1-2-3	5555
1-2-5	2222
5-5-5	1234

But I want to have it summarized.

It would be nice if somebody could halp me with this problem.

[Gysbert_Wassenaar · Accepted solution]

OrderNumber looks like a dimension to me, not an expression. Try a pivot table with BusinessUnit and OrderNumber as dimensions and =1 as expression.

[#3]

Hi, ok this works. Now I get this:

But with the column "1" it looks not that nice. Can I hide this?

[jonathandienst]

No you can't - but the expression is not required for a pivot table. Delete the expression and uncheck the Suppress Nulls option on Properties | Presentation.

[#5]

Perfect, thank you so much.