Skip to Content
0
Former Member
Feb 10, 2011 at 10:19 AM

How to Suppres a Row in Cross Tab?

28 Views

Hello All

I have a cross tab where I wish only to show the result of the calculation.

The cross tab is like this

Header............Period

Sales..............X

Costs..............Y

Cost/Sales.......Y/X

What I want to show is the result only Cost/Sales

Header............Period

Cost/Sales.......Y/X

Hiding the Cells Sales and Costs but still using their results in the calculation.

Is there anyway to do this? As at present I can only supress Sales and Costs and minimize their size but this looks silly as you get a result like

Header............Period

Cost/Sales.......Y/X

With Space in between.

Any help would be appreciated.

Thanks

Phillip