ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table order problem (https://www.excelbanter.com/excel-programming/316993-pivot-table-order-problem.html)

Kamyk

Pivot table order problem
 
Hello all!

I have generated pivot table. Similar format of the table I have created,
looks like this:

Parameter WK 200446 | WK 200447

D4_A_1 3 1
D4_A_2 4 2
D4_A_3 5 3


I want the parameter to be unsort. I mean to be with the same order as in
the source data.
The value of WK 200446 \ WK 200447 is count of parameter in the source data.
For example if the source data looks like this:

Parameter WK
D4_A_1 200446
D4_A_1 200446
D4_A_1 200446
D4_A_3 200446
D4_A_3 200446
D4_A_3 200446
D4_A_3 200446
D4_A_3 200446
D4_A_2 200446
D4_A_2 200446
D4_A_2 200446
D4_A_2 200446
D4_A_1 200447
D4_A_3 200447
D4_A_3 200447
D4_A_3 200447
D4_A_2 200447
D4_A_2 200447

That`s why I would like to have such pivot table:

Parameter WK 200446 | WK 200447

D4_A_1 3 1
D4_A_3 5 3
D4_A_2 4 2

Can I manually set the order of Parameter field?

Thanx in advance
Martin from Poland




All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com