1 Reply Latest reply on Oct 7, 2015 7:57 PM by Douglas Everson

    How to show custom total values?

    Tae Hoon Lee

      Hi all,

       

      I have a quick question about how I can show custom total values in the table.

       

      Below is the screenshot of my current worksheet.

       

      As you can see, I have placed "Grand Total" for the column.

       

      On the left hand side, it shows different categories such as gross sales, trade, allowance, non trade sell in, etc.

       

      I would like the grand total to show "Total for Gross Sales" and "Total for Sales Deduction" (Sales Deduction = Trade + Allowance + Non Trade Sell in + Non Trade Sell Out + Cash Discount) for each Division. I want to apply the same logic for "Ratio", "Value Difference", and "Ratio Difference".

       

      How can I achieve this?

       

      I have uploaded my workbook in the Tableau Public Server. The name of the worksheet is "YOY Division".

       

      Here is the link to my workbook:

      https://public.tableau.com/views/NewSalesDeductionV08/YOYDivision?:embed=y&:display_count=yes&:showTabs=y

       

      I really need help on this, please help