it worked with this set as a column TOPN("Fiscal Year and Month"."fiscal transaction dt",1 by "Dept(CF1)"."Dept Id"). Seems to be solid.

Sorry jumped the gun. Still struggling with this one. Trying to get the row of data/amounts for the last transaction date without it accumulating amounts.

Interesting Srini. I was trying to grab last record in the fiscal year as the way it is put together. The amounts in sum of the fields are cumulative and double up unless I grab the last transaction date. I thought maybe in column I could flag the one with maximum date and just filter on flag but I stumbled on filtering…