Loading ...

Adding calculated columns in Excel pivot table | CLEARIFY - Page 1

Posted in: QQube Technology    Excel

Adding calculated columns in Excel pivot table

Subscribe to RSS
  • Harold

    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.

  • admin
    Answered

    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.

  • Harold

    Thank you. That's exactly what I needed.

Page 1 of 1 (3 items)