Is there any to arrange the rows in custom wise in pivot table?

Question & Answer
,
1

I want to arrange the rows as per my wish in pivot table like based on priority wise.

Capture
Capture1913Ă—844 89.2 KB

Like in below order

  1. Brand Frist migration
  2. BF rename
  3. Adsu-LBR
  4. CRB
  5. BE manual node creation
2

Hi @hripraa
you need to define a sort order for the elements and use that definition.
grafik
BR

3

@ErikG Which is showing only 2 options Ascending and descending but i want to change the row by my wish.
Is that possible?

4

You must formulate your wish in a calculated field and use that field.

e.g.
field value = A B C

ifelse("field value"="A",1,"field value"="B",3,2)

5

@ErikG What is “field value” here?

Im confused with this field value.
When i use this field value, which shows a error in calculated field.

Pls help me with any video solution

6

“Field value” is the field you want to create the sort of.

You want to sort the field “field value” based on your ifelse logic.

In my sample A B C will be assigned in the new field to 1 3 2. I can then sort with (AVG) the new field and A B C will be sort as A C B or B C A.

7

Thank u so much it is working fine

1 Like