Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Alignment with pivot table

Hi All,

I need assistance in  alignment of  dimension in pivot table .

Please find the attacment for understanding the problem

Thanks

1 Solution

Accepted Solutions
ecolomer
Master II
Master II

First, create the pivot table:

- Dimension: Dept

- Expressions: Sum (Sales) and %

p49.png

second, dragging the (Dept) column to bring it above the columns

third column format

View solution in original post

6 Replies
ecolomer
Master II
Master II

Can you explain better your requieriment, please?

or upload a example to work with it

Anonymous
Not applicable
Author

Hi ecolomer

This is current design .

Dept Sales[Sales %]
Admim10010%
Dev20020%
Finance300305

Below is the desired output

Thanks

ecolomer
Master II
Master II

Is this?

p48.png

daniel_kusiak
Creator II
Creator II

Hi,

For each Dimension and Expression set Alingment to Center under Chart Properties->Presentation.

Anonymous
Not applicable
Author

Dear Enrique,

Please explain the steps !

Thanks

ecolomer
Master II
Master II

First, create the pivot table:

- Dimension: Dept

- Expressions: Sum (Sales) and %

p49.png

second, dragging the (Dept) column to bring it above the columns

third column format