Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a straight table that count top 10 no. of viewings in expression (selected as expression total that shows value "21") as follow.
Name | Viewings |
21 | |
Alan | 8 |
Garth Hill | 7 |
Ben Klein | 3 |
Ivan Totton | 2 |
jana hipkiss | 2 |
john edward | 2 |
John Morrison | 2 |
Kenneth Smith | 2 |
Martin Phillips | 2 |
Michael Burgess | 2 |
Now how can i display on the window title with total of viewings : 32 instead of 21?
Thanks!
Any one?
Hello Dinesh,
According to me, I think it's not possible to display the result of the expression in your window title, because you don't have dimensions when you want calculate something in the title.
I tried to reformulate the expression with aggr() function, but it doesn't work. Moreover, you want a top 10 but the rank() function return a top 12 (because of the ex-aequo values). It's possible to resolve this problem in the chart's expression, but not in the title.
Regards,
Amand