pivo- table

  1. S

    Pivot table with multiple slicers, need a search box

    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...
  2. S

    Pivot Table Adding Field or Column

    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...
  3. T

    Pivot table - percentage between 2 columns Max

    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...
  4. D

    Get Average of already calculated averages in Pivot Tabel

    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...
  5. S

    Filter on a Powerpivot Table (Value field)

    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...
  6. D

    Looking for a Power Query solution to group dates into mixed month billing period

    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...
  7. B

    Pivot table macro and text instead of numbers help

    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...
  8. G

    Not showing sub-totals in Pivot table using VBA

    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...
  9. B

    Not able to plot pivot table and chart for row data

    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...

Some videos you may like

This Week's Hot Topics

Top