pivot

  1. D

    Pivot table text not values

    Hello everyone, I am using Excel with a table dump from ERP system. In the example below I am trying to create PT that returns the text value instead of number or formula. In the column ADHOCV all the values under should be ADHOCV not 0. Is this possible? I can do find and replace but this...
  2. B

    Calculating Variances (Value and Percent) in Pivot (not using power pivot) - is it possible?

    I have financial data that I need to show variances against a number of dimensions. I need this in pivot so that I can use filters to create automatic views for different audiences (e.g. Divisions and Heads of Areas). In the pivot there are roll ups, so example income as a level with sub level...
  3. B

    How to change Pivot Format

    I have data of image links in excel. Some of my SKUs have 2-3 images. But the problem is all of them are in different rows. I want my images to be displayed as Main SKUs in Rows and their multiple image links in columns in front of them. Please help, Thanx. Raw Data Main SKU Image Links...
  4. N

    REPORT NEEDED TO COMPLETE USING EXCEL TOOLS

    I have some problems with doing these reports, can anyone help me? https://onedrive.live.com/view.aspx?resid=30339B713429A885!1448&ithint=file%2cxlsx&authkey=!ADupp2Ig0QcS5Lg The report must be done with some condition mapping following the mapping rules which I have added it in the first sheet...
  5. A

    Consolidate sheets into one tab?

    Hi, I have a workbook containing multiple sheets with same formatting in each tab. I am trying to take all the sheets and create a pivot table containing the data from each sheet. Is this possible to do? I am trying to avoid using a master tab because the information changes daily and the same...
  6. A

    Subtotal above the pivot table

    Hello Guys, I have a Pivot table, where i need to add new row above the pivot table and show the subtotal of each column till last available Column. (Pivot range may vary) Below is the code which i tried but it was not working correctly. Please help. LR = ActiveSheet.Cells.Find("*"...
  7. G

    Excel Re-arranging data - row to column

    Hi, I have this data on excel SCALE_NO SCALE_NAME SIZ 1 DUAL 3942 1 DUAL 4346 1 DUAL L/XL 1 DUAL M/L 1 DUAL S/M 1 DUAL XS/S 2 ONE SIZE O/S 3 TALLA L 3 TALLA M 3 TALLA S 3 TALLA XL 3 TALLA XS 3 TALLA XXL 3 TALLA XXS if possible rearrange with some steps like...
  8. S

    Generate metrics for one vehicle when fleet, make or specific registration is selected

    Hi, We've got a fleet of 58 vehicles that we used to manage by registration, so for example we would get individual requests per vehicle for MOTs, servicing, breakdowns, repairs etc. Every entry is tied to an individual vehicle, so there are hundreds of entries but it's fairly straightforward...
  9. H

    Problems with pivot and calcuated fields!

    Hi All, I have a major problem with Pivot – here a short description. I’m trying to calculate how many units per departure we have on a ferry. The raw data looks like following: Date Month Time Product Length Amount Departures 23.3.2020 March 18:30 CAR 6 2 1 23.3.2020 March 18:30 VAN 8 2...
  10. V

    Weighted Utilization % in Pivot based on Volume, Plant & Product Group

    Hi All, Really hoping for some help here in calculating the correct weighted utilization. The idea is you have multiple plants within each product group and within each plant you have multiple lines with different possible volumes. Based on the volume assigned to the line you have a...
  11. A

    dynamic cell selection

    I am using =Datedif() to determine time frame of some stock. It's currently set into a pivot table as I only need some of the data from the main workbook, which is different to the workbook I am using. Because not each row has a date reference, there are a number of them that show a #VALUE...
  12. F

    Counting streaks from an excel table

    Hi I am trying to track the reliability of vehicles within our fleet, every rota we complete an evaluation of the vehicles where they will be tested on various criteria and scored as a pass or fail (with a fail marking a 1 on an excel table). This data would be better understood by our...
  13. P

    Unpivot my data - Excel / PowerQuery / SQL

    Hi I have summarized data in the following format: 2021 2022 2023 admin 1 2 2 I would like to convert this so it is presented as: admin 2021 admin 2022 admin 2022 admin 2023 admin 2023 I've tried PowerPivot and the Unpivot option. That doesn't seem to show in this...
  14. L

    Move Pivot Table to align with last row of other column

    I'm pretty new to using VBA, so please excuse my lack of knowledge or choice of words to describe my question Alright so I have a; -Pivot table 1 @ (A25:B29) -Pivot table 2 @ (A31:B34) -A regular table @ (D1:K50) ~ this table is constantly changing it's height (row count) could be K50 upto...
  15. E

    Massive Pivot Table filtering

    I have a pivot table that is reading thousands of records. The pivot has three filters, one of which is the amount of time since yada yada yada. I want it only to show things within the past 5 days, but I don't want to manually click through the filter for a thousand different possibilities...
  16. S

    Need Help with pivot table and week numbers

    Hi I am trying to get pivot table to show me sales data for a particular store for a each week number of the year. I have my main data in the below format Date Month Week No Day MMM-DD Warehouse Store Sales Values 30/12/2019 Dec 1 30 Dec-30 West Shop 1 20 31/12/2019 Dec 1 31 Dec-31 West...
  17. B

    Pivot Table Filter On "Difference From"

    Hello, I cannot figure how to use a pivot table to filter a pivot table by the largest or smallest "difference from" the prior year. The use setting is to see only the top 10 growth or loss versus the previous year. My sample dataset is as follows: Year Region Amount 2020 1 100 2019 1 90...
  18. K

    Filter two pivot tables in one sheet based on a cell value

    Hello, I'm trying to create a macro that will filter two different pivot tables in one sheet based on a value in cell A1 of the same sheet. I have some code earlier in this macro that's working fine, so I don't show it here. Below is what I've written to filter the first pivot table in the...
  19. C

    What Code Or Macro Can I Use To Substitute Text To Column

    Hello Everyone. Presently I have Many Raw Data below to section out. What's beautiful, all the following data are similar: Here is an example in row "1", in column "A" only : 0: {c: 9, close: 9, yield: null, referenceDate: null, date: "1997-03-01T00:00:00", …} In this Case: How can I Keep...
  20. T

    Filter Multiple Pivotfield items based on cell values with VBA

    Hy, I am a novice in Excel and VBA and I would like to somehow do the following with a VBA code, to be able to automate my work: I receive a list of items in Range(A1:D1) for example. After that I have to go through this items and switch to visible all items in Pivotfield which was formerly...

Some videos you may like

This Week's Hot Topics

Top