For example if i am trying to create a table visualization and i need to use dimension fields [Continent],[Country],[State]. also i need to use measure field as [Population].so in this view i can see the population of State. what if i want add column to the sheet view which shows population of Continent as well.is there any method to achieve this without using LoD functions?
Table calcs! You can use Total and partition by "Continent" and address by "Country" and "State".