-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
pivot and power query
-
R
Collecting data to an Invoice
Hi I have a set of date from a table that i need to structure and merge in to a resonable overview. user shall only choose project and date from->to i have used Power Query and pivot to streamline the data, but the selection part is not easy i nee uder to choose project subproject date how do...- Runejors
- Thread
- pivot and power query power query
- Replies: 2
- Forum: Excel Questions
-
R
What do you called this? A Grouped/Aggregated field list pivot?
Hi Everyone, Looking for an answer & help here, I've never seen this kind of fields in Pivot, 1. how do call it? any source link to read? 2. It's from a .CUB files, can we create these from .CSV raw data? 3. Tiempo is an aggregate from Column Year & Month in the CSV, how to create this? Thanks...- radian89
- Thread
- olap cube pivot pivot and power query
- Replies: 1
- Forum: Excel Questions
-
Pivot Column into "Actual" and "Budget" values
Hello all, See table for example data set. I have transformed 2 files, one "Actual", one "Budget", and they are appended. How do I unpivot the "Source.Name" column in a way where I have two columns, "Actual" and "Budget", their corresponding value for GL Code, GL Name, and Cost Center? I will...- TheMacroNoob
- Thread
- pivot and power query power query unpivoting
- Replies: 1
- Forum: Power Tools
-
G
Headcount Using Hire Date & Term Date Power Query
Every week I run a report from our HRIS and drop a CSV file into a folder that is connected to Excel via PQ. I use the cleaned-up data to "feed" pivot tables and use them in a dashboard. I have no problem getting a current headcount, but I would like to be able to get a headcount for each month...- goob90
- Thread
- dax pivot and power query power query
- Replies: 0
- Forum: Excel Questions
-
K
Getpivotdata using "SUMIFS" FORMULA for Stock management.
=GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,"")) I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result... Get pivot data using "SUMIFS" FORMULA for Stock management. HELP ...- krunal123
- Thread
- #excel #comparison #excel #formula #confused #excel #vba #checkin/out #inventoryreporting #pivot table#fiilter #pivot tables #tables #power query #question #sumifs pivot and power query
- Replies: 2
- Forum: Excel Questions
-
K
How to make Date Period vise Filter on Pivot Table ?
- krunal123
- Thread
- #condition formatting #excel #comparison #excel #pivot #excelformula #filter #logical #if #excel2016 advance fillter dynamic filter excel & ilogic pivot and power query pivot table pivot table % formatting powerquery
- Replies: 0
- Forum: Excel Questions
-
G
Power Pivot Possibly?
So I have to create what will be in essence a small database in excel for reasons far too long to go into. My thought is to create 3 tabs with 3 named tables then create a power pivot to drill down and return the needed information. If there is a better way to do this PLEASE feel free to tell...- Gesyca_is_joy
- Thread
- excel pivot and power query tables and relationships
- Replies: 3
- Forum: Excel Questions
-
W
> and < Symbol in Pivot Table
Ive created a data set using Power Query. From that Data set I am creating a pivot. The pivot works fine except for one thing, the date field includes the greater than and less than symbols and I cant figure out how to get them to go away. Any suggestions? Something Ive noticed, is that the...- Warpug
- Thread
- pivot and power query
- Replies: 0
- Forum: Excel Questions
