DS - Suppress columns in a crosstab when there is no data

other Xcelsius - Crystal Dashboard Design
1

Hi All,

I’m new to Design Studio and I want to know if there is an option to suppress columns in a cross-tab when there is no data.

I’m using HANA calculation view as data source for my DS dashboard. When I run the dashboard for current year, I have 3 months with no adjustments data (attached a screenshot for the same). I want to know how to hide these columns in DS as the option of hiding them (if that’s even possible) in HANA level is not feasible.

Design Studio Version: 1.6

Any help with related to this is highly appreciated.
Crosstab view.JPG

mitchamdon :australia: (BOB member since 2011-07-05)