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