4 Replies Latest reply on Aug 24, 2018 6:54 AM by philipp.gntzel

    How to solve the combination problem table calc vs. LOD


      Hello altogether,


      currenty I am facing a problem -which I think I am definitely not the only one having.


      I have simple sales data. The case: Compare the average yearly change of one location to the average yearly change of all locations.


      I have put the location as a filter. What I would love to do now (but tableau forbids it), is doing a table calc for the difference percentage to the foreyear for one location and then on top of it build a calculated field with an LOD, which excludes the location filter....so that I can divide the one thing by the other: location 1 / location all. Unfortunately you cannot combine table calcs and LODs. So how can I solve this problem :-(?