3 Replies Latest reply on Oct 15, 2018 1:47 PM by tanvi khanna

# Weighting

Hi,

I need help with some weights.

I have to analyze each region separatedly and then by the whole country, weighted by the population of each region.

The measures to be analyzed, will be amounts in percentage, not averages. The weights are fixed by region and I already have them. These weights work well when we measure in each region the whole sample, the problem arises me when it is separate by any variable or a filter is applied, as the weighting of the region should vary according to the size of the sample after applying the filter or perform the separation (eg if 40% of the country's population is from a region, their average weight is 0.4, if we separate by men and women this region may have 36% of the population of men and 44% of the population of women so we must use weights of 0.36 and 0.44 respectively in each panel) how can I make a weighting factor that gets  adjust when we apply filters and crossovers, and to turn to calculate percentages

• ###### 1. Re: Weighting

Hi Santiago,

Please post an example Tableau Packaged Workbook and I can take a look into this.

• ###### 2. Re: Weighting

Tom,

Thank you for the willingness to help

• ###### 3. Re: Weighting

Hi, if you dont mind sharing, how were you able to do that?

I have a problem by region.

If it is region then I need th value to be avg(country values)

if country values then normal calculations that I have created

Please refer: weighted data at different level