Skip to Content
Former Member
Jul 05, 2016 at 06:13 AM

Supress Subtotal If the Columns under Group is less than 2


Hi Folks!!

I am facing this issue while formatting one of my Crystal Report.

Its having a Cross Tab in which several Groups are there among them under Group "Year" let say I am having Column "C", And there a Subtotal Column which is showing total for column "C" for each value of Group "Year".

The requirement is the Subtotal Column should not be visible if the if Column "C" is having a single Record.

In the screenshot the first Subtotal "2016 Total" should not appear as only single record is there under year 2016.

Please help me to get this done..!!

Thanks in advance.


Crystal Query.png (14.3 kB)