Straight Table: Combining Cells for a Same Value?

[#1]

Hello!

I have a Straight Table like the following:

ZONE	ACCOUNT_ID
A	001
A	002
A	003
B	001

Is there any way to show it like this? Without using a Pivot Table

ZONE	ACCOUNT_ID
A	001
	002
	003
B	001

Like grouping a same value and combine the rows?

Thank you!

[anandathome]

I don't think there is another way (without using Pivot Table) in qlikview to do this.

[jonathandienst]

Hi

I am confused by what you want. If you want pivot table appearance, why not use a pivot table?

Jonathan

[#4]

Because I want to use the Sum of Rows in Expression and I don't have the option to do that with Pivot Table

[jerem1234]

You can use a pivot table like is mentioned above and you can use partial sums. Then if you want, you can have a separate expression for your total like:

if(dimensionality()=0, totalexpression, expression)

Hope this helps!