Skip to Content
0
Jun 17, 2014 at 10:50 PM

Adding a dummy column for text in crosstab report

870 Views


I created a report using crosstab to show trended months per column & details per row. Now I'm trying to add additional columns to the crosstab report to display other pertinent info (not calculations, just text pulling from the database). I read from various threads in the forum that I can create dummy columns to accomodate this, but I don't know how to do so. Can someone please guide me in doing so? If creating dummy columns is not a solution, please advice on what's the best way to add text columns to a crosstab report. Any help is truly appreciated. Thank you.

Original report:

Emp Name Jan Feb Mar Apr May Total

Doe, John 20 17 30 28 33 128

Wish to accomplish:

Emp Name Emp# Dept# Yrs Employed Jan Feb Mar Apr May Total

Doe, John 12345 6010 8 20 17 30 28 33 128