pivot table 2016

Afternoon, I have a pivot table references multiple tables (when creating the pivot table, i chose "add this data to the Data Model"). I have the relationships I need created, but when I go to select calculations to enter a formula and it's grayed out. I have sales data based of months, and...

Hi I have a table that has new columns added often. Is there a way to have the new column automatically updated to the pivot table? Thanks or the help. Laurie

The following is a screenshot of a pivot table I have created in Excel. The odd thing is that the column total of the distinct count is being displayed as <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...

Hello all, I'm having trouble with a pivot table I'm trying to assemble. My intention is to have the pivot table display Job, Budget, Cost and Difference. My pivot table source is time card entries with equipment and labor costs. The sheet looks similar to the first sheet below. <tbody> Date...

Hi All, Please note:- I know about slicer but don't want to use and wants a vba macro only. Below is my query I've 3 pivot tables in same excel worksheet. All 3 pivot tables have 5 report filters and out of them 4 report filters are common. I want to use a drop down list from cell b4, b5, b6...

In Excel 2016 I'm trying to filter on a pivot table to include only the top 20 accounts (coming from a very large cube containing 20,000 + account IDs). I know it is very easy to filter on top 10, by simply clicking on Value Filters and choosing to include only Top 10. I was hoping there may...

I have two pivot tables, both tables have dates in one column and other column is the % difference from the top oldest date. I added a slicer to control both pivot table dates which works fine. Say the slicer is currently on 1/1/2017 and the prices are show % difference from 1/1/2017, now when...

I keep getting the following error when I try to refresh a pivot table (not Power Pivot). "We couldn't get data from the Data Model. Object reference not set to an instance of an object". I tried re-selecting the data source, but would get the same error message. I checked to see that I have...

Hi All, I have table which have sales located from different countries and the contact person. It's possible to do pivot table that shows the country (first column), cities (second column) and the contact persons (third column)? Below is a sample what I want...

I am sure this question is elementary, but it has me stumped. I have customer visit data on Days of the Week and Store Locations. I don't get what is happening when I create a routine pivot table. When I stick the Days of the Week in rows, everything begins great. When I stick a Store...

I have a pivot table that is showing two values. However, some rows have zero for both values, some rows have both values, and some rows just have one of the values. If I use a filter for one of the value columns is hides the row irrespective of a value in the other column. I need some way to...

Hi everyone Here is my problem. I have an excel table with different columns filled with the same answers : yes ; no ; n/a ; - Here is a visual idea of what this table looks like : <tbody> A B C yes yes no no n/a no - - yes n/a yes no </tbody> And so on. Now, I would...

Hi I have some sales data, I use Pivot Tables to organize the data into countries. So I have a column of countries with a column of sales for each country. Now I would like to sum up the sales into various groups, namely: 1. Germany 2. Europe 3. Non Europe I can do this manually by using...

Hello All, I've been attempting to make some comparison's in a Pivot Table but have run into some struggles. I have a PT setup in Excel 2016 with 2 columns "Month" and "Year", and they columns represent sales data for their respective months and states in a corresponding row. As such I would...