2 Replies Latest reply on Sep 20, 2017 8:06 AM by vandana punchhi

    Tableau 10.3.1- Grand Total with Table Calculation Filter- Wrong Grand Totals

    vandana punchhi

      Hi,

      I am trying to get the Grand Total for only the Top 5 products by sales, but when I use Analysis -> Totals -> show column grand totals, I am getting the Grand total for all the products( not just the top 5). I am using Tableau 10.3.1 and trying to use the new Apply to total but it is still yielding the same result.

       

      Attached is the sample sheet. If the Apply to Total function is not applicable in this case, what could be a possible workaround to calculate the Grand Total for only the top 5 values?

       

      Regards,