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