Hi All,
I have a crosstab with ,employee id,employee name,pay type,project id in the rows, date in the columns and entered hours in the measure. Please find the attached file of the crosstab.
We want the employee id and employee name to repeat for every new paytype and project ID.Please find the attached image where i have placed the expected output we want. Would like to know if this would be possible using a crosstab ?
Regards,
Raghuvir
Out of curiosity, I googled and experimented a bit. This only seems to work with a relational package, otherwise I think you might be out of luck. If you are using relational, try this.
- Create a data item that concatenates all the nested columns on your rows: [Employee Id]+[Employee Name]+[Pay Type]+[Project ID]
- Drop this new data item onto the crosstab the the far left on the row, left of Employee Id.
- Delete the Employee Id column from the crosstab.
- Select the new far left column, the data item you created in the first step.
- In the properties pane, under Text Source find Source Type and change it to Data Item Value.
- Set the Data Item Value to Employee Id.
Worked for me, with the relational package caveat. As much as I'd like to take credit, I synthesized these steps from a couple of posts by others.
If your only reason to do this is for export to Excel, and you always want it that way, I believe there is a system-wide setting in a properties file to accomplish this automatically whenever exporting.
Thanks bdbits
will try the steps as you have guided us.
yes we want to export it to excel, thats why we want it that way.
Regards