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: https://clearify.com/wiki/view/4750/creating-calculated-columns
Mr Excel is also a great resource on the use and limitations of calculated fields in Pivot Tables. https://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