Pivot table in power query (on the excel not Power BI)

[deniztopcu]

Hello,
I would like some help making the following Pivot table in a "power query".
I have attached the final version of my file. Transpose is necessary, but due to too many titles, I couldn't.

Picture of the table below. It will make the job much easier and simpler in a situation like the first picture.

inpowerQuerypivot.xlsx dosyasını indir - download

 

[RoryA]

Why do you want to create a pivot table in PQ instead of using an actual pivot table?

 

[deniztopcu]

Why do you want to create a pivot table in PQ instead of using an actual pivot table?

less excel sheets, simpler excel, less visible clutter.

 

[RoryA]

I don't understand. Surely you have to put the pivot table somewhere, so there are the same number of sheets either way.

You can't have multiple rows of headers in PQ so you are going to end up with very long column headers for most columns.

 

[deniztopcu]

I don't understand. Surely you have to put the pivot table somewhere, so there are the same number of sheets either way.

You can't have multiple rows of headers in PQ so you are going to end up with very long column headers for most columns.

I downloaded it as "pivot table report" it would be 1 page instead of 2.
I have a problem like this.

I am currently renewing with these codes.

------------------------------------------
Private Sub CommandButton1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
        
Sheets("Combined_Financials").Range("Combined_Financials_Sector").ListObject.QueryTable.Refresh BackgroundQuery:=True
Sheets("Symbols_Price").Range("Combined_Price_Sector").ListObject.QueryTable.Refresh BackgroundQuery:=True
End Sub
--------------------------------------------------------------

How do I refresh the "Combined_Financials_Sector" in the background.

 

[RoryA]

I still don't understand - whether it is a pivot table or a query result should not materially change the amount of space it takes up.

Your code is already specifying a background refresh.

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Pivot table in power query

topic closed

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[deniztopcu]

Bir hatırlatıcı:

Çapraz gönderi (aynı soruyu birden fazla forumda yayınlamak) kurallarımıza aykırı değildir, ancak bunu yapmanın yöntemi Forum Kuralları'nın 13. maddesi kapsamındadır .

Takip etmeyi ve kuralın sonundaki bağlantıyı okumayı da unutmayın!

Çapraz gönderildi:

Pivot table in power query

topic closed

www.excelforum.com

Yukarıda verilen bağlantı(lar)ı tekrarlamanıza gerek yok, ancak soruyu başka yerlerde yayınladıysanız , lütfen bu bağlantıların da bağlantılarını sağlayın .

Gelecekte çapraz gönderi yaparsanız ve ayrıca bağlantılar sağlarsanız, o zaman bir sorun olmamalıdır.

Bir cevabınız varsa, görmek isterim.
Eski kurallarınızda bunu bu kadar zor bulma. kendini göster.
Bunun bir çözümü olmadığını biliyorum ama kimse çıkıp da bana kendince bir şey söylemiyor.
sadece kısıtlamalar kurallardır... pehh

 

[jdellasala]

It is really difficult to determine what your ultimate goal is. If your intention is to use PQ to GROUP data, it could be daunting, and you could run into that "Date as Header" problem (which can be overcome, but is a speed bump).
Also, I'm a huge fan of PQ and Pivot Tables (especially with the Data Model), but you might want to consider using Array formulas to create Data Validation lists and FILTERED tables to present the data needed.
SORT, UNIQUE, and FILTER are your best friends, and they have plenty of pals too!
Just a thought....