1 of 1 people found this helpful
If you could add an attached workbook that is always best for these types of problems. Otherwise, we can't really play with the data.
In the meantime, my guess would be the following:
-Wholesaler on rows
-Date on columns. Year first. Then Month. (filter for only Q4 by dragging quarters to filters and selecting Q4 - assuming calendar year)
-Add US Sales and India sales to columns after date.*
-For total sales use the ''Totals" options in the analysis ribbon or the Analytics pane that Tableau has and move it to the left.
* I'm foreseeing an issue with your sales measures, though. A recommendation might be to have one "Sales" Column and then another column that is "Sales Type" and would indicate India or US.
Something similar with my dummy data:
Let me know if this helps!
Hello Matthew Risley,
Thank you for your quick help. exactly I wanted like in screenshot.
I tried but not able to separate Grand total as a column from Year or month calculation context. could you please upload your tableau test file along with you missed steps in highlighting to me.
The only steps that may not be clear are the totals: So here are some screenshots:
Drag totals from analytics pane:
Move to the left:
Alternatively you can also use the Analysis Tab to do some of this work as well.
Anonymous Workbook.twbx 5.7 MB