How can we add another row on top of column headers which would club different columns together and give a common name

[Aditya_Raj]

is there a way i can club different columns together like how we do in excel
basically i want a header above let say the last 3 columns in this table i want to have a common header above it which should say Variance. refer to the 2nd image

[duncan]

Hello @Aditya_Raj !

Can you try the solution from this post?:

How to use rank with parameter & calculated field

Hi, I have a parameter to switch between two field - sample size & z-score. I want the functionality to switch the parameter and the crosstab view should rank according to selection. sample size is calculated field - distinct_count({id}) z-score is a calculated field consisting of avgOver & stdevOver… both calc field works fine individually and provides the correct output, so nothing on that end. But when trying to use rank(z-score) or rank(sample_size) I get error Expression rank({Z-Score…

Let me know if this is what you were looking for!

[duncan]

Hello @Aditya_Raj !

I marked my comment above as a solution, let me know if you need any additional help!

[cravoori]

Hi @duncan - not sure that I followed the solution from the other post - can you elaborate on how using Rank can allow you to add headers to combine fields?

[achangx]

I am having the same issue and this most definetly is not the solution