Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with a dimension "name" column and an expression column. My expression:
count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID)
It shows something like:
Name | expression |
XXXX | 3 |
AAAAA | 3 |
BBBB | 2 |
DDDD | 2 |
SSSS | 2 |
JJJJJJJ | 2 |
QQQQQQQQQ | 1 |
WWWWW | 1 |
EEEEEE | 1 |
RRRRRRR | 1 |
I need to show ain a text box the sum of this expression, how can I do that?
Hi,
try with
=Sum(Aggr(count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID),Name))
Just copy your expression and paste into the Text on the General tab of the Text Object with an = sign in front. Then you can format the Font in Font tab and move the transparency on the General tab to 100%.
Its not working, it shows 3, instead of 18.
Hi,
try with
=Sum(Aggr(count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID),Name))