How to hide Y columns with blank data

[Leonardo deana]

Hi,

if I have a visuzalition with the table below. How do I hide columns with blank data in the visuzaliation example below:

Observe that for 2019 i don`t have 2Q values yet, therefore I don`t want to show that column only for 2019. If i filter by quarter and select only 1Q. that will remove 2Q data from 2018 as well.

As Is:

 

 

 

 

2018

2019

 

 

Platform

1Q

2Q

1Q

2Q

 

 

platform1

30

50

36

 

 

 

platfrom2

25

25

45

 

 

 

 

 

To be:

 

 

 

 

2018

2019

 

 

Platform

1Q

2Q

1Q

 

 

platform1

30

50

36

 

 

platfrom2

25

25

45

[Leonardo deana]

This is a cross-data table

[Shashank Gurnalkar]

Hello Leonardo,

 

I tried with the sample data and I am getting the desired behavior. I may need to have a look at your data table structure. Or you can refer the attached analysis file and create a similar data table structure to get the required behavior.