I have a straight table with dimension Physician_Name and expression Product_volume.
In this straight table I am showing all the physicians based on geography selection. I want to show the first physician name in a text box that means first row Physician name from the straight table. User can sort table based on Product volume so the order of table will change. everytime I need the first record from that table.
Is there any way to pick first row value from a straight table?
Every object like chart and tables show values depending on dimensions and expression so, if you want to show a value outside the object you should have to replicate an expression with the same dimension. This is not possible in a text box, otherwise you could use a trick that is design a new table where the dimension limit show only a row and so displaing the first row as you need
