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".
I don't know of any methods for making a customer grand totals field. What I've done in the past is create a separate worksheet with the totals I want and play around with formatting to make it appear seamless on my dashboard.