We have an application where we would like to show different columns, but for some of the categories on the horizontal axes, the columns are completely empty. As there's no information displayed in those columns, it would be great if they could be hidden. Example: If we have the following data table (--- indicates no value)
Cat1 Val1 Val2 Val3
A A1.1 --- A3.1
A A1.2 --- A3.2
B B1.1 B2.1 ---
B B1.2 B2.2 ---
a crosstable as shown in the attachement is obtained. But First(Val2) has no entry for Cat1=A and First(Val3) no entry for Cat1=B. These two columns should be hidden.