locked
Three Questions on 1. Edit a calculated column. 2. List all measures created in PowerPivot. 3. Disable the automatic pivot table refresh. RRS feed

  • Question

  • Does anyone know how to do the followings? 

    1.  Edit the formula of an existing calculated column.

    2. List all measures created in PowerPivot in the workbook.  

    3. Temporarily disable the pivot table auto-refresh.


    BI Analyst

    Thursday, April 18, 2013 3:07 AM

Answers

  • Hi,

    1. Er, retype the formula in the box exactly as you would do in excel.

    2. See this blog post. Basically it links to an .odc file that once downloaded means you can get a table of all measures in a couple of clicks.

    3. Presuming you are using 2010 then there is a trick using the normal pivot table field list where you can effectively use the 'defer layout' option. See Rob Collie's post on the subject. In 2013 then you just check the box.

    • Marked as answer by BIAnalyst Thursday, April 18, 2013 4:29 PM
    Thursday, April 18, 2013 3:40 AM

All replies

  • Hi,

    1. Er, retype the formula in the box exactly as you would do in excel.

    2. See this blog post. Basically it links to an .odc file that once downloaded means you can get a table of all measures in a couple of clicks.

    3. Presuming you are using 2010 then there is a trick using the normal pivot table field list where you can effectively use the 'defer layout' option. See Rob Collie's post on the subject. In 2013 then you just check the box.

    • Marked as answer by BIAnalyst Thursday, April 18, 2013 4:29 PM
    Thursday, April 18, 2013 3:40 AM
  • Hi Jacob,

    Thank you for your help again!  All your tips work perfectly.  Regarding (1), how can I miss that?!  LOL! 



    BI Analyst

    Thursday, April 18, 2013 4:31 PM