pivo- table

Pivot Charts.xlsx hi i have inserted a sample file where i get macros to do automatic pivot table number formatting. The macro is turned on by right clicking on a pivot table field and selecting the toggle button. Now when you insert new fields the number formats get applied automatically...

Hello, I need help to find a way to hide zero value calculated items in a pivot table. So far I have tried a number of tricks at no result. I have a database for CO2 tons emissions for 2021 for a number of scopes and subcategories for some countries and locations. I need to compute 2025...

Hi forum, i have a table with thousands of rows like this Week Sales Returns 1 4000 150 2 1250 3 7800 340 4 3444 I tried to create a pivot table (using data model option) to create a Return Rate measure (returns/sales) but i got an error message...

Hi everyone, I hope you are all doing well! I need some help with a macro that I'm trying to make. Every month I get a data sheet named 'Mutaties' from a few customers, which I then turn in to a Pivot Table. Tho when doing this for 30 customers.. it gets repetitive. I'm trying to build a...

Hi guys, please help me. I need to expand my Excel pivot table without overwriting the other pivot table below. Is it possible to do this using VBA? Would anyone have the code? I need that when I click the button to expand the data, the other table below is "pushed" so that it doesn't overwrite...

Hi, I'm looking for a way to have my buyers take photos and have Excel look in a folder for the photos. Below is an example of current code i use. But I would like a quicker way to have Excel look for a photo. To code this for 200 photos would take a long time. The product for it to look up...

Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.

I have a multiple calculated fields in my excel pivot table. The field is in the values part of my pivot table and I sum them. I want to add a slicer to select them or not. i.e. I want my slicer to select basically hide and show AA1,AA2,...,AA8 in the chart and table. This is normally easy if...

Hi, I've have CUBERANKMEMBER formulas to list items selected in a slicer. How can I list items NOT selected? Example: ="TOP 25 BY MODEL "&", LOCATION "&CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer_loc_code_ClassSales,1)

Hi, I have a power pivot table with 6 slicers. Date, invoice number, vendor and so on. but I have over 3000 invoices and to scroll takes to long and is hard to do. rather than using each slicer to filter the next and narrow the list. I would like to use the search box to find the invoice...

HI EXPERTS, I HAVE PIVOT TABLE WHICH IS GATHERING DATA FROM TWO DIFFERENT TABLES. RELATIONSHIP IS WORKING FINE (I THINK) BUT I AM STUCK AT ADDING A "FIELD" OR A "COLUMN" TO GET THE RESULTS BY WHICH WILL BE THE END PRODUCT OF DEDUCTION FROM "TABLE 1" TO THE ITEMS OF "TABLE 2". BOTH VALUES ARE...

Hi everyone ! I come for your help on Pivot tables. So I have done a pivot table, which depicts the maximum of a value on a specific date, for several parameters. See image in this link: http://www.noelshack.com/2018-49-3-1543999976-capture.png So I have the Max values for X and Y on...

Hi There, I'm new here and have searched if this has already been discussed, but with no luck, so apologies in advance if this has already been resolved/explained on another thread. I have a data sheet with sales per customer ID over a year. On a pivot table I can easily calculate the average...

Hi I'm trying to filter a list of items received. I'm drawing the data from my POWERPIVOT. I have received items many times and need to know the # of weeks on the floor. Then I want to filter only items that are new IE first received in the last 4 weeks. I've tried these with some adjustments...

Hello Cannot seem to find an answer on here unless i am poor at searching. I bring my data into PQuery clean it and send it back to Excel. I then run a PVTable but like all Credit Cards they run between two dates. Mine is 20th to 19th of next month. I am trying to show in a PVTable a table...

Hi Guys, I am very new to pivot tables and I was just wondering if anyone can help. I have a pivot table set up at the moment for out of stock orders. Report Filter - Account number Example : 12008003 Row Labels - Order Number Example 818042187 Row Labels - Item Description Example Apples...

Hi, For some reason I am getting ‘run-time error 1004 unable to set the subtotals properly of the pivotfield class’ when I run the below code. It appears to run fine upto 12 but on the 13th it comes up with this error can anyone help? Dim ptf As PivotField With...

All my data are captured in row series and not able to plot pivot table and chart as it involves several different tables example shown for one year bu this data continues for 5yrs need help for 1. i want to plot pivot table and chart for the first set of data format 2. if i plot for one...