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!
Maybe you should use "Sum of Rows" instead of "Expression Total".
Hello,
You can modify the behavior of your total column with test on the first row. Modify your expression like this :
if(rowno()=0, your_total_expression, your_top_10_expression)
Regards,
Amand
Thanks for the response!
I have dirlled down top 10 rows by limiting Max number "10" on properties-->presentation-->Max number "10"
My expression is count(distinct id) and dimension is "name".
could you please help on expression with based on above?
Thanks
Dinesh
If I understand your problem, I agree with the John's solution ie select "Sum of Rows" instead of "Expression Total".
If it doesn't work as you want, can you attach your qvw file please.
I have attached .qvw file. Hope you could help me.
Thanks,
Dinesh
Dinesh,
The rank() function let you do a ranking according to your expression. See the attached file.
I have modified the calculated dimension in order to add the ranking (I select the Top ten values), I have used the John's solution and I have added an expression so that you understand the ranking.
Because of the ex-aequo values, you have a top 12 rather than a top 10.
Regards,
Amand
Thanks Amand,
This is really helpfull but i still want generate only top 10 for report which i am producing.
Any additional help would be appriciated!
I think it's that you want .
Here, I modified the expression in order to display only the ten first values, and I changed the sort.
Regards,
Amand
Thanks!
But how could i display expression total on window title?
Any insight would be much appriciate!
Regards,
Dinesh