I'm using the job cost report built into Qqube but I want to add additional calculation columns to the pivot table. I have tried everything I can think of but I can't get these columns included as part of the table. I have searched Microsoft and Qqube and followed their instructions but they just don't work. I am using a trial version. Don't know if this matters.
Can anyone tell me how to insert columns in a pivot table in Qqube? The normal methods don't work.
This wiki will assist you: http://community.clearify.com/wiki/view/326/excel-pivot-tables-calculated-fields
Mr Excel is also a great resource on the use and limitations of calculated fields in Pivot Tables. www.mrexcel.com
Lastly, you can open up on one of the examples in the configuration tool. In the job_costing.xls file the last field "Estimate vs Actual" is a calculated field.
Thank you. That's exactly what I needed.
Choose a location