![]() First, you must determine how to frame the calculation. ![]() You can use a table calculation to show percentages of total instead of raw dollar values. You can drag Region to the right of Sub-Category to organize the view first by sub-category, and then by region. The view now breaks out sales by region, in addition to year and sub-category. A small triangle will appear to indicate that the new field will be inserted to the left of the existing field. We can see that the chairs and phones sub-categories had the highest sales in every year.ĭrag the Region dimension to Rows and drop it to the left of Sub-Category. Each cell in the table displays the sum of sales for a particular year and sub-category. ![]() Now you can add a measure to the view to see actual data.ĭrag the Sales measure to Text on the Marks card. For more information about changing the layout for row and column headers, see Define Table Structure. Columns with headers plus rows with headers means that a valid table structure now exists. Tableau aggregates the date by year and creates column headers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |