The portfolio slicer is wonderful, so useful and easy to use. I'm finding it a godsend.
There are a couple of new measures which would really help me prioritise new purchases but I’m struggling so wondered if you could help please. One is the median of Cost Basis and the other is median of Total Value s shown on the Holdings tab. I’ve tried (and failed) to do this as I get a repeat of the value of the symbol not the median of all the items shown on the column.
I’m on Excel 2016 so have the function available, but can’t s get it to work on the Cost Basis or total value measure.
Any help you could give would be brilliant