Perhaps this to replace your current Media2 expression?
I'm not certain the dimensionality of the total row will be 0, but I think it is. If so, then it's basically saying "if you're on the total row, calculate it by dividing the second column by the first column, otherwise calculate the value normally".
As for not seeing hotels A and B, rather than suppressing when the dimension is null, I believe you need to suppress when the expressions are null. Properties -> presentation -> suppress zero values and suppress missing.
Thanks a lot for your answers.
I think I´ve solved the problem.
The big problem was that I can´t get a 'Total Expression' (in Total Mode) for the field 'Media2' if some of the Expresions I use in 'Media2' doesn´t have a right value in his 'Total Expression'.
The 'Media2' Expression was something like this [Precio]/[Noches], but I dind´t know how to get a right value in TOTALS for this fields.
So now I have been able to get a right value in all Total Expressions for all my fields using the function aggr.
Now I have in Expressions [Precio] and [Noches] something like this:
So I can use the Total Expressions in Total Mode without problems.
I attach my example.
Thanks a lot
Top3-TotalExpressions.qvw 121.8 K