'Is there a way to show the max value of a pivot in the pivot?

I need to get the max of a row in pivot and show beside it. If it is not max then it should reflect as 0 (zero). Why pivot? I am planning to use the slicer so that it will adjust based on the selected slicer criteria. Is this a dead end? Or are there any other way to do this?

I need it for an interactive graphs.

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source