How to return value from one row above when filtered? Building dynamic filtered pareto

Is there a way to return the value from one row above when filtered? To add context, I am trying to build an 80/20 Pareto chart utilizing a sort of balance sheet formula in column B where cell B5, as the first row of data, returns a copy of the cell contents in C5. However, I need to be able to filter to different sales reps in col E while maintaining the unique formulas in B5 vs B6. In other words, the first row of data changes when the filter on column E is activated.