1 Reply Latest reply on Aug 27, 2018 11:50 AM by Deepak Rai

    Grand Total with Parameter Filter

    Mallory Piedmont

      I currently have a parameter that displays top N customers by total sales.

      When I add the grand total into view, I would like to aggregate only the sum of sales in view.

       

      In summary card, you can see that the sum of sales is lower than the grand total being displayed in the view. After some research, I have learned that this is because Tableau is calculating the grand total at a higher level than what is in the current view. Has anyone been able to solve this grand total problem using a LOD expression? 

       

      Tableau Grand Total with Parameter Filter.PNG

       

      Thanks!

      Mallory