How to adjust column headings / Settings - Please see details

Hi All,


I have data from 2 data sources one for headcount and other for team movements.

When I create a cross table, the headcount data is also getting splitted between transaction type.

I want column headers like 1. Headcount 2. Transaction type and below Transaction type Entry and Exit should come.

Currently the Entry and Exit split is shown below headcount as well, how can i avoid this?

Please see attached dxp file.

Thank you in advance.




Binary Data test_data.dxp170.73 KB

(1) Answer