I was going through excel sheet formulas for sales team target & I came across a sheet that is formulated. I really want to know how to put the formulas as options in a drop-down as shown in the picture I have attached herewith. Please help. Thanks in advance.
To my knowledge that doesn't work such way. If you are working with structured table, list of aggregation from drop-down is only in Total row at the bottom of the table. On the top, or at any other place, you only could make the reference on Total.