How to adjust column headings / Settings - Please see details

[sanju d]

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.

[Nawaz Ali Mohammad]

Insert the column "HeadCount" into the main table based on Team as matching column.Then use the HeadCount column in Vertical axis along with Team column.