5 Replies Latest reply on Feb 15, 2016 11:01 PM by Shinichiro Murakami

    Ratios and Aggregates

    Gowtham Chandran

      Hi I am new to using Tableau, I was playing around with the super store data and came up with a doubt. I created a calculated field as [profit]/[sales]. When i pull this calculation into the view, it throws up wrong values. Is that something to do with the default aggregation?

      Kindly help me understand this better.

      Also in sheet two when I tried calculating sales percentage with the formula [sales]/[TotalSales], Cant mix aggregate and non-aggregate measure pop up. How can this situation be handled.