Hi and welcome to the forums!
It sounds like you will probably need to do Advanced compute using. Can you post the sample workbook when you get into work?
Thank you for your interest and offering me help!
I can't, that's the problemm I woudl not have lost time wrinting manually a sample if I could. I have very few free time at work, so I have to do these things at home, and there I use Tableau Public and I don't have iexplorer so it does not work saving online.
It is more a theoretical question, that is why I used txt-like tables.
It seems like I cannot use Compute Using, because I need the LoD of City for addressing, and then the result is unwantes, as I need a LoD of Country.
I'd like to know how to do constant (in the sense of ATTR()) custom-level aggregations (in my sample would be the second field AVGofAVGs) in Tableau without relying on WINDOW_funcs + LoD. I'm sure I am forgetting something basic.
I just want to get last table shown working. Its a root hierarchy dimension + 2 fields. One of those is an ordinary AVG(Revenue), the second one is the one I am actually looking for, I think the example is straightforward. And after all, I am asking for fishing rods instead of fishes so don't get me wrong
I don't know if it helps, but have you tried placing State/City on the Level of Detail so they can be referenced in a calculation, but not necessarily show up in the view? This type of question is difficult to answer without an example--you could mock one up fairly quickly in the Sample data provided by Tableau, and post it here so you can get the best possible help available on the Forum.
I finally realized I need them in LoD as you said.
And I learn also to filter using IIF(INDEX=0) for hiding repeated calculations