calculation pivot table

  1. U

    Calculation in Pivot

    Hello, Is there an easy way to get 'OT divided by Grand Total' in the pivot table? I need it to be a field in the pivot table so that the calculated fiend changes when putting new Cities in the pivot table. I really apprecaite any help!! <TABLE style="WIDTH: 670pt; BORDER-COLLAPSE: collapse"...
  2. E

    How to calculate percentage from Pivot Table

    May I know how do I write the VB code to calculate the Percentage of sum/count using the same pivot field in pivot table calculation? Note: SumGood_Apple and TotalCount_Apple are generated from the Pivot Table using the same pivot fields. And I assume the Percent of Apple can also be generated...
  3. kc.crow

    Elementary pivot table question that I'm just not seeing

    Hello Have what seems to be an easy pivot table question that I haven't been able to get right. Below is my data Excel WorkbookBCD11DivisionDataTotal12CB_CATCount of GID43713*Count of Completed Form214CIECount of GID215*Count of Completed Form*16Industry AutomationCount of GID149717*Count of...
  4. D

    Pivot table

    Whats the best way to calculate 4Q sales if sales for Q1-Q3 are known using a pivot table? The table includes sales for different product category, and regions for the same company by quarter.

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...