By: Oliver Linley
Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.
Sometimes we want to calculate the percent of total of a variable, but those totals add up to over 100%! What's going on?
In those cases, the dimensions we use in the view likely have overlapping members. For instance, a single customer could have purchased at all our stores, meaning that the percent of total for our number of customers is skewed.
If you're using Tableau Percent of Total Table Calculations, fixing this might require using an LOD. FIXED expressions to the rescue!
Want help setting something like this up? Book an hour with Ollie! Want to dive deep into Tableau? Check out our upcoming Tableau classes!
Resources
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!