1
  • Pivot table Year over Year % increase

    I have created a pivot table. I have a list of years across the top row and the expense amounts under each column. I would like to do a year on year comparison to the previous column. Example 2013-2014        2014-2015         % Diff $354,378,067    $329,570,055       ?? I...

    bekgrealy5 pointsBadges:
  • How to collapse data in a Pivot Table in Excel 2007?

    I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collapse all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to collapse.

    Babyphat5 pointsBadges:
  • problem with zero’s after macro has run

    Ihave a pivot table that gets data from a server.In my pivot table some cells do not have values.After the macro has run then on my report template all values are pasted, and the cells that was empty is now filled with zero's.What can i do so that in the report it still shown a blank cell,not...

    RVDW5 pointsBadges:
  • why is a blank cell returned in pivot table when data exists?

    I have a pivot table with one cell that appears blank. when I double click on the total for that row, the field is not blank. Why is the data not displaying in the pivot table? Show all is selected in that field header.

    MightyTightYouth5 pointsBadges:
  • Pivot table issue

    Hello, I have created a rather large pivot table and what I am trying to do is on the pivot table itself, as I uncheck something from one of the categories, I want the unchecked items to log a history of what has been unchecked, while the checked items stay. I have already gotten the items that...

    Cevalogistics5 pointsBadges:
  • Pivot Tables – I need more than rudimentary calculations

    Does anyone know of a site that exchanges calculation information for Pivot Tables???

    Firewoman15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following