1 Reply Latest reply on Sep 8, 2015 1:48 AM by Vladislav Grigorov

    Display Total for the Dimensions

    mehak jaggia

      Hi All,

       

      This is something urgent I am looking for. In the workbook you can see that I am having market as the Dimension , I am using the "Grand Total" for Market dimension. Now I am using this Market Sheet as the "Filter " and want to display Market based on the selection in the dashboard. Suppose if someone select GrandTotal, it should only how GrandTotal not all the markets and then GrandTotal, similarly if someone select market UK then only UK should be displayed not UK and GrandTotal.

       

      Market_Selector.png

        • 1. Re: Display Total for the Dimensions
          Vladislav Grigorov

          Mehak,

           

          off the top of my mind, if you're able to make a union of the data with itself in the data connection, but in the second part of the union replace your Market dimension with 'Grand total', then you will have the data for the totals as regular data in your dataset. Consequently, you may disable Tableau's native functionality for totals, and just display the plain tables, and your filter action will function properly when you click on the grand total.

           

          One caveat though, the grand total will be independent of your selections of separate markets - e.g. if you select Germany, France and Finland, and the Grand Total, the latter will not reflect the sum of the 3 countries of interest. Therefore you may opt to make the action work only on a single select.

           

          Hope this helps,

           

          Vlad