pivot table

Hi guys, I am currently not able to connect the various charts i have created on my dashboard to the same slicer filter I added. For some reason, Only the first Pivot table shows up when I click on 'Report connection. I have tried to fix it with some of the solutions shared on this Thread but...

Context... I'm working with a very large file but I will simplify it with the following: I have static data in columns a through d (static datal and look up formulas in columns H through H fetching data from a report (report data). The static and report data should reconcile one for one. Columns...

Hi Experts Reference to my older post - VBA to Filter Column Labels using Filter List I got help from one of the experts at the forum. Until recently the below code was working well. Today when I actually needed to use filter I realized the code clears all filter from columns labels but does...

Hi Excel Gurus, I am attempting to set up a spreadsheet where I can update data in tab 1 on a monthly basis, then refresh the pivot in (tab 2). In tab 1, when I paste the new set of data on top (same format), when I refresh the pivot (tab 2), my power query disappears - no data appears in the...

I have a pivot table filtered by "Pozo", showing me those values for each Pozo historically. Next to it, I have a regular table with formulae (referring to the data in the PT) to evaluate the evolution of these parameters up until today, updated daily. One of these formulae calculates the...

Hi Excel Gurus, I have a spreadsheet, two (tabs) are data input manually. I used a power query to format the data. Then I used a pivot table. To refresh the table, I must select "Data > Refresh All" Is there a way to display the last refresh date and/or refreshed by who? for when my pivot...

Hi There I have a Pivot where in the "Columns" Strategic Region as 3 Regions (Emerging, Europe, North America). There are 2 attributes I want to bring data in under "Values (Sales Amount T1 LY and Sales Amount T1 YOY). As you can see the pivot is pushing the Grand Totals for the 2 attributes...

I have a Pivot Table that by default lists months with January and February listed before November. I have searched thoroughly, both online and within Excel, but have not found how I can sort so that Nov 2022 and Dec 2022 precede January 2023. The time field that the Pivot Table is pulling from...

Hello All, I have 3 files have different data formats and fields. There is one common field amongst the 3 reports. The Location ID. The three Files would have different details each of which are connected by the Location ID. First one, the employee register. Second is the Monthly Costing...

Hi everyone, I have the following data set, that I plan to continue adding lines to throughout the year. I want to create a pivot table where I can see the success rate (where booked = Y) for each combination. For example what percent was booked in January through google for a brand. The...

I would like to create a pivot table that looks like this: ABCDEFGHIJKLMN1JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal2Felix S3 Yearly Salary$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$...

Hi, I am trying to calculate averages per site requiring use of the distinct count function. I've used the following calculations to determine these averages: - Total count (calculated using the sum total) - Column 2 - Survey count (calculated using distinct count) - Column 3 - Average count...

Hello Everyone, I´m having an issue with a pivot table from the data model. I want the quarterly subtotals to show monthly average rather than sum, but the option is grayed out: Is there a way I can work around this? Thank you!

This for an exercise. I am using Excel 2021 for Mac. The dataset we're given is labeled by hours 1-24 in rows and individual dates (from 1/1/20 to 12/31) in columns. It lists out all of the prices by date and by hour for "Jim's Store" and then does the same thing for "Jane's Store" directly...

I have a table that has columns for tracking weather via METARs. METARs are messages that are used by aviation to pass weather readings. They are usually generated hourly, unless otherwise required, every day. I have a table that has 99K rows of data. Each day has between 22 - 28 rows of...

I have a pivot table connected to a data model and I keep changing its shape according to my needs, it would be helpful to have a way of bookmarking a certain layout an putting in a name instead of duplicating the pivot table tab and having a dozen of duplicated tabs, will the spreadsheet get...

Hello, I have a power pivot table I am using to summarize some data. I am using it as a daily report and outside the pivot table I pull out and summarize specific data related to individual departments. Two of the Lines I want to combine the total units produced. Which works fine, when both...

Hi I have created two pivot tables from two different data sources. These data sources have one thing in common which is that both have column with date. I want to have one "master" timeline that would control both pivot tables. I am assuming I would need to create VBA module to control it...

Hi, I have a table in the following format: DateInserted IdentityNumber TeamName MMYY 21/12/2022 0101040504 Team A Dec-22 10/05/2022 0101590849 Team A May-22 07/06/2022 0101632916 Team A Jun-22 06/06/2022 0101750412 Team Z Jun-22 25/10/2022 0101770383 Team B Oct-22 22/12/2022...

Hi all, I need your help with a table I'm trying to build and need to run it every Monday. I think this can be achieved with VBA. What I need to do: - At the beginning of every month, the table needs to erase the details (or simply don't take in consideration the values as I only care about...