Attached the file for your reference. On the Transaction type i wanted only the first "BIOH" to show for table calculation and the rest to not show up for table calculation. Add always "BIOH" will the 1st line.
So the results should be as shown below. when i do rank (index() function) it still does the table calculation for even the filtered rows.