Pivot Table Values

[NPandelos]

I have a pivot table that has a Priority column in it. If I go to a cell in that column and put a 1 it fills the entire column with the number 1. I'm hoping to be able to change this priority level in the Pivot table with out going back to the source data. Is this possible?

 

[Sergius]

Hello! Create a duplicate field (in my case, "salary"). Go to the parameters of this field, go to the second tab and select “The largest to the smallest” (see photo), as well as select the field by which you need a rank (in the photo of the “teacher”).

And this is what happened.

Book1.xlsm
	F	G	H	I	J	K	L
10	Teacher	Salary			Row Labels	Sum of Salary	Rank
11	1	250			1	250	3
12	2	280			2	280	2
13	3	125			3	125	5
14	4	140			4	140	4
15	5	102			5	102	6
16	6	320			6	320	1
17	7	140			7	140	4
18	8	80			8	80	7
19	9	35			9	35	8
20	10	21			10	21	9
Sheet1

 

[NPandelos]

I think I'm missing something, I'm not following what you did.

 

[Sergius]

The source table has two columns: teachers and salary. The summary is built on this table. In the summary, a duplicate of salaries is created by transferring salaries to a window. As a result, you will have two columns with a salary. By the right button on the second copy of the salary and select the parameters (last item) in the menu. In the window that opens, select the second tab and in it in the list select the rank. Below the names of the columns in the source table will be displayed. Choose teachers. Then you can give a new name to this column (I gave it the name Rank). As a result, you will have a summary as in my message above.