Unit description in Cross Tab
My Cross Tab Report is ready to go except I need it to show the original unit description instead it shows all the same description.
I have Each, Hour, Feet and etc. Right now it shows all of them in Each which is wrong. How can I show it true description in the column itself. Sorry I could not copy and paste what it looks like. Example...Row # 1 Name Is Product Column # 1, 2 and 3 shows: 1 EACH (on top) $ 500.00 (on the Bottom). Then the Total add all three. Now Continue to next row may be in Feet but it shows Each. How do I correct this?
Hope I explain this okay since I cant show you. I did try to send you attach; not sure if it works. Thanks!