Alignment with pivot table

[Anonymous]

Hi All,

I need assistance in  alignment of  dimension in pivot table .

Please find the attacment for understanding the problem

Thanks

[ecolomer]

Can you explain better your requieriment, please?

or upload a example to work with it

[Anonymous]

Hi ecolomer

This is current design .

Dept	Sales	[Sales %]
Admim	100	10%
Dev	200	20%
Finance	300	305

Below is the desired output

Thanks

[ecolomer]

Is this?

[daniel_kusiak]

Hi, rgvavihs

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

[Anonymous]

Dear Enrique,

Please explain the steps !

Thanks

[ecolomer · Accepted solution]

First, create the pivot table:

- Dimension: Dept

- Expressions: Sum (Sales) and %

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

third column format