STRAIGHT TABLE ISSUE

[#1]

I have a data which includes Policynum and Module. When the policy renewes it is assigned a new mod .

In the attached sample  Policynum '1701655 '  have 10 modules.  I want the data set to always come back with only the latest module entries.

In the attached sample I would like to see only one row for each policy

PSL 1701655 does not show any No.Of Docs  but  Policy Number 0114166 does show that  .I am able to see No. of Docs for Policy Num 1701655 if I click on Policy Number filter.   How  can I make the No of Docs visible all times for the Latest Mod for each Policy.

[jolivares · Accepted solution]

You may create an expression like:

FirstSortedValue(NO_DOC_REN,-Aggr(Max(POLICY_MODULE),LOB,[Policy Num],POLICY_MODULE))

[#3]

Can you please update my sample and attach here