Merging column names in Tableau

0
votes

I wish to merge the Q2 and Q3 columns into a single column and row and rename it to Q3 vs Q2 and I would like to rename the 2018 row to QoQ. The first image is where I am at and the second images is where I want to get to.

Is it possible to do this in tableau? Unfortunately I can't share the workbook due to data sensitivity issues, apologies.

where I am

where I want to be

Update: I have duplicated my date measure and renamed it to what I would like to display which has worked for the first row of the column but the second row still shows 2018 and I have no idea how to change it to 'Q3 vs Q2'.

enter image description here

2
tableau-api

2 Answers

1
votes

Instead of using a table calculation as you have, you can create a calculation to achieve your desired result. This is done by isolating the quarters.

Something like this:

(sum(if datepart('quarter',[Date]) = 3 then [Pa Requests] end) - 
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end))
/
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end)
0
votes

Right click on the Q2 column header, and choose ‘hide’ to only display the second column

Similarly, try right clicking on column headers and editing an alias