Hi All...Need Help !!!

[Excel_Learner_99]

Hi All,

Hope you are good. I am new here, registered to get some help from experts for a problem I could never get answer for.

I have the following Pivot Table.

Month Revenue
Jan 5000
Feb 3500
Mar 5400
Apr 4800
May 4200
Jun 5100

I would like to another column (Max Revenue) as part of the Pivot Table, i.e. displays "Yes" for the Maximum value across these months and "No" for others, i.e. I would like to have as below. I need this column as part of the pivot table so when future data is added, its gets updated accordingly.

Month Revenue Max_Revenue
Jan 5000 No
Feb 3500 No
Mar 5400 Yes
Apr 4800 No
May 4200 No
Jun 5100 No

Can someone help please ?

Thanks

[arlu1201]

Hello Excel_Learner_99,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.