0 Replies Latest reply on Dec 6, 2018 12:14 PM by Yao Lu

    How to calculate from different dimensions

    Yao Lu

      Hi Everyone,

      I have some problem of calculating data from different table, the following is the introduction:

      1. Two dataset: one is benefit value by benefit type,Quarter and country; the other one is the head count by country and Quarter.

      2. I have blended two datasets by country and quarter,  and calculate the average Headcount per year.

       

      I want to have the result of the benefit per headcount of every benefit type and every year. For example, the benefit value of commute(benefit type) in 2015 is divided by avg headcount in 2015. How could do this in tableau?

       

      Thanks for in advance for your help.

       

      --Yao