I have a table where I have a calculated dimension and it works fine. However I have a request to show the same information on one line (as a variable). The variable should be used in NPrinting reports and should be presented as a text. The variable should be something like this:
If (Date=today AND Sum(condition1)<X AND Sum(condition2)>Y), to be displayed list of all people for which this set of conditions is true.
I have limited access to the back end so I'm looking for a front-end solution. I tried different ways to make this, however I nothing works for me. I'm failing to find a way to display only the people that satisfy the above.