• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Sort top 10 by calculated column in pivot table

    I have two years of sales and created a column which calculates the difference. I want to sort for the biggest differences and can't seem to get it to then only sort based on that single difference column descending. Help will be appreciated.
  2. C

    Using a field outside a pivot table

    I If I use a calculated field, does the user have to go into that calculated field to change the value? I was trying to keep it simple for end users without a lot of experience?
  3. C

    Using a field outside a pivot table

    I would like to place a field [% increase] outside of my pivot table which could be used within a calculation within the pivot table to create a "what if" scenario such as Sales * [the % increase]. I haven't been able to see how to refer to an external field. Any help would be appreciated. Cindy
  4. C

    Hidden column still showing up in chart

    I have a pivot table with sales for 2 years and budgets for 2 years. When I chart it, I don't want the budget for last year to show up. So I hid that column. When I create the chart, the budget shows up for the hidden column. I thought the default was to hide them from the chart. I'll...
  5. C

    List Box Error

    I am working in Excel 2010. I have a form with a listBox that allows multiple selections. When I check an entry further down the list, the first item is automatically also selected. How can I fix this problem - thanks, Cindy
Back
Top