pivotable

  1. I

    Create a pivotable with Pivot BI as data source

    Hi all, I have data that I have been taking care of through Power BI and I need this data in Excel now. The easiest for me is to have this data in a Pivotable, so my aim is to create a pivotable in Excel with the data I worked on through Power BI. thanks ! N.B.: cross posted Create a...
  2. K

    Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???

    i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????
  3. K

    HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? (=+A2 According This)

    HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????
  4. K

    How to Pull data One file to both file ????

    How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..
  5. K

    How to match same invoce no. & get data "FILE -1" TO "FILE -2" ...

  6. K

    Party name According how many invoice to Show count , But Not Show count Total Invoice

    Show Result : 3 (Pleased Show this Query........................................)
  7. S

    Merging With Same Cell Value and Matching Other Column Value

    Hello Experts, Following is actual data and the common column in both sheets is "Style No.". The two sheets have thousands of records. Lets say first sheet is with prices and order quantity and the second sheet is with actual shipped quantity. TABLE 1 WITH PRICES...
  8. M

    Loop through slicer in pivotable prints too many pages

    I found a vba code that I copied on this forum that lopps through a slicer and selects / deselects each name and bring up the relevant data for that person and prints it. It works but for some reason it keeps creating prints about 104 pages when there are only 39 names in the slicer. The last...
  9. P

    Pivotable not Updating

    Using VBA: My spreadsheet inserts the formula to copy data from another spreadsheet that will have been selected by the user and could be in a normal file system or sharepoint. I don't know how to automatically create a data connection which may sort this problem. I then force a Calculation...
  10. H

    Calculating % in Pivotable

    I have total overdue amounts in Col E on my Pivottable I am trying to calculate the % per Item as a % of the total on Col E on the Pivotable, but it returns 0.00% =GETPIVOTDATA("Total Overdue ",$A$3,"Name","Sales")/SUM(OFFSET(E3,1,0,50000)) It would be appreciated if someone could...
  11. T

    pivottable groupdate and CalculatedItems

    I have a code it doesn't work correctly, please help me Sub addhideitems() Dim WSD As Worksheet Dim PTcache As PivotCache Dim PT As PivotTable Dim Prange As Range Dim Finalrow As Long Set WSD = Worksheets("sales") Dim WSR As Worksheet For Each PT In WSD.PivotTables PT.TableRange2.Clear Next PT...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top