I have a column named Customer Name and one filter on the same column which has names , like David , Bruce,Rohit.... Now the Task is I want to show the current selected name from filter of Customer Name to the KPI as to show the client this sheet data is for which client,Can any one provide any solution
=Only([Customer Name]) will show the value of the field [Customer Name] if only one value is selected in that field. You can use that expression to show that value in a text box on the sheet.
