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?
Here is the Similar Thread Answered by me on This. Basically, It would only Show you the Grand Total For Whatever Top N you have in View.
Hope it Helps