OTBI Analysis - Count & Rank

David Oldfield

Hello,

I currently have the following Count formula:

COUNT("Worker"."Person Number" BY CONCAT(CONCAT("Target Bank"."Target Bank Account Branch Number", ' '), "Target Bank"."Target Bank Account Number"))

This works well, however I also need for this to Count based on the below Rank formula:

RANK("Payroll Relationship"."Payroll Relationship Creation Date" by "Worker"."Person Number")

Where the Rank = 1 only.

Is this possible to combine together so this only counts where the Rank = 1 only?