Feb 05 2021 11:42 PM
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.
Feb 06 2021 02:07 AM
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.