CODEWITHSUNDEEP
tableau-api
TheGoat
TheGoat

Reputation: 2867

Merging column names in Tableau

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

Upvotes: 0

Views: 1410

Answers (2)

Alex Blakemore
Alex Blakemore

Reputation: 11896

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

Upvotes: 0

Bernardo
Bernardo

Reputation: 3318

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)

Upvotes: 1

Related Questions