How to retain the old computation in the same Excel Pivot Table of the same field?

[nemypresbitero]

My scenario is this, I have 2 grade tables for June and July.
June Grade Table
A - 100-95
B - 95-90
C - 89-80
D - 79-Below
July Grade Table
A - 100-97
B - 96-93
C - 92-89
D - 88-Below
I am computing grades using these tables. What shall I do to retain the old grade computation for June now that I have the latest table for July. I have to compute it in the same calculated field in the same pivot table. My goal is to have 1 pivot table so that it will automatically retrieve grades for June with old table and retrieve grades for July with new table.
Help me please... Thank you all in advance.

 

[Legacy 143009]

My scenario is this, I have 2 grade tables for June and July.
June Grade Table
A - 100-95
B - 95-90
C - 89-80
D - 79-Below
July Grade Table
A - 100-97
B - 96-93
C - 92-89
D - 88-Below
I am computing grades using these tables. What shall I do to retain the old grade computation for June now that I have the latest table for July. I have to compute it in the same calculated field in the same pivot table. My goal is to have 1 pivot table so that it will automatically retrieve grades for June with old table and retrieve grades for July with new table.
Help me please... Thank you all in advance.

I didn't get your scenario extactly. But INDIRECT() seems to me the function you are looking for.

It can be something like =INDIRECT("'"&TEXT(TODAY(),"mmmm")&" Grade Table'!$A$1:$A$4)...something what ever you will do..

For example the expression above will return $A$1:$A$4 referance values from related sheet according to today's date

 

[Legacy 143009]

One little fix: =INDIRECT("'"&TEXT(TODAY(),"mmmm")&" Grade Table'!$A$1:$A$4")

I dont know how you can implement this to your pivot table because I don't know your exact scenario. Maybe you should gather all information on a seperate sheet which will populate the grades automatically with the function above. And buil your pivot table from this sheet

 

[nemypresbitero]

Thank you for the reply Flashbond, i really appreciate it. But I think I didn't provide the exact goal of the question. My goal is to categorize the grades through numbers (and that is ratings 1, 2, 3 and 4) and not letters, so that I can get the average ratings by using pivot table for the whole year and for a each month. And there are times that we have to change the grade bracket for each rating like what is described in below table.

Now my new table would be:
June Grade Table
Rating 1 - 100-95
Rating 2 - 95-90
Rating 3 - 89-80
Rating 4 - 79-Below


July Grade Table
Rating 1 - 100-97
Rating 2 - 96-93
Rating 3 - 92-89
Rating 4 - 88-Below