manipulate the query output

[gdanalakshmi]

I have a crosstab query.

Its output is like the following

DeskNo Total NChurn VoicePortion VoiceOnly

I would like my output to be the following

DeskNo NChurn (VoicePortion-VoiceOnly) VoiceOnly Total

How do I accomplish my goal??


I have 1 idea.
Loop through each record of the query and then append to a new table.

Is there a better way to do this??