Doesn't display total on window title?

[#1]

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!

[#2]

Any one?

[#3]

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