5 Replies Latest reply on Feb 26, 2016 7:59 AM by tancrde.fde

    Problem with calculated fields at aggregate level

    tancrde.fde

      Hi,

       

      I am tearing my hair out on this one, as I really don't understand why the calculated fields fail to give me the right results at the aggregate level, while at the country level the formula works fine. This is not the first time I face such issue, but usually I manage to find a walk around through LoD expressions.

       

      To put it bluntly, this is what Tableau shows me:

       

      Capture.PNG

       

      This is what I should have:

      Capture.PNG

       

      As you can see, the online markets figures are wrong in the Tableau output. Those were calculated by computing sum([total market per country]) * [penetration rate per country].

       

      I have attached the workbook for further information.

       

       

      Thanks a lot!