Get instant live Excel expert help with Pivot Tables

I need to add an equation to a value field in a pivot table.

need to learn pivot table v look up and h look up

Every month we copy the worksheet we are working on over, rename the worksheet for the current month, update the figures, and then update the pivot table on that worksheet to pull from the new figures. For some reason, this no longer works. We tell the worksheet to pull from July's tab and then hit refresh, but it's still pulling from June.

I need help in establishing conditional formatting in pivot table. I have two sources of data that I am able to import onto two worksheets. The first table has item numbers, width of the item, height of the item, price of the individual item. The 2nd table has the model number, width, height, and total number sold for the year. I am needing a few pivot tables. I need a price grid of individual models by width and height (width is my column, height is my row, filtered by model # - got that far) I need to add a coloring (conditional formatting) to the values by sales. I need another pivot table that can do a grid that can compare the price of the base model to the chosen model.This grid would have a percentage of the difference in price. still with the width in column and the height in the row. Beyond the basic single price grid by size....I am lost

Make a pivot table for the Group Segment "Big" and show Revenue and Expense by Subdivision.

How to use pivot table in excel? I need to pull employee numbers and names and match them on a new worksheet using pivot table?

Start with the Excel file “Lab 7 – model.xlsx”.  You need to create a Pivot Table showing monthly unit sales, by Category, by Manufacturer, for the year of 2014. The report will look as shown:

I have a Power Pivot table with lots of slicers, one of the slicers is total transactions which is formatted as currency in the data model, but it displays as a numeric value on the slicer, how do I change it to currency?

I have a pivot table for a price grid. Width in the column, height in the row, filtered by model #. Is it possible to have the pivot table have conditional formatting based off the number of doors sold? EX: 4x8 unit price is $446.00 but I want to see it yellow because only 2 were sold. Can use the formula bar in conditional formatting to say any unit price that sold between 1 and 5 is yellow?

Please reference EXP_321 I am trying to get conditional formatting based on a column that is NOT included in the value of the pivot table. My pivot table has values based off column g "Price" while I want the conditional formatting to be based off column L "# Sold" EX: If I sold between 1 and 5 of my 5x8 model 600 the unit price of $446 will turn yellow.