I am trying to create a text object which has a description of my number 1 job opening and the number of open requisitions for that job. I currently have a TOP 10 open requisitions by job. I'm using a calculated dimension to get it. Here's the calculation I use for the dimension : =if(aggr(Rank(Count(Distinct(Requisition)),SF_Job) <= 10, SF_Job)
and the expression is : Count(Distinct(Requistions)).
I would like a text object which show me SF_Job and number of Requisitions for that job.