Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need assistance in alignment of dimension in pivot table .
Please find the attacment for understanding the problem
Thanks
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
Can you explain better your requieriment, please?
or upload a example to work with it
Hi ecolomer
This is current design .
Dept | Sales | [Sales %] |
---|---|---|
Admim | 100 | 10% |
Dev | 200 | 20% |
Finance | 300 | 305 |
Below is the desired output
Thanks
Is this?
Hi, rgvavihs
For each Dimension and Expression set Alingment to Center under Chart Properties->Presentation.
Dear Enrique,
Please explain the steps !
Thanks
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