Skip to main content

Posts

Showing posts with the label #unmergetableau #repeatedrowheaderstableau #displayrepeatedrowstableau

Un-merge row headers Tableau

Un-merge row headers Tableau Option 1 Open Tableau Desktop and connect to Superstore sample data. Drag the Category and Sub-Category dimensions to the Rows shelf. Double-click Sales in the Measures pane. Ctrl-click Category and Sub-Category in Dimensions, right-click the highlighted fields, and then select  Create  >  Combined Field . Drag the combined Category & Sub-Category field to the far left on Rows. Right-click Category & Sub-Category on Rows, and then clear  Show Header . Option 2 Open Tableau Desktop and connect to Superstore sample data. Drag the Category and Sub-Category dimensions to the Rows shelf. Double-click Sales in the Measures pane. Click  Analysis  >  Create Calculated field...  Name the calculated field, enter the following formula and click  OK :  [Categories]+[Sub-categories] Drag the new calculated field to the far left on Rows. Right-clic...