Wow..bravo function! It works like charm.Very nice tutorial, i learned a lot throughout your teaching and those links you provided has upgraded my ski...
Hi Catalin, The code i just copied from other's online solution, do not know the logic was not correct 😛 Thanks for your code. 1)As i know if w...
Hi Catalin, I tried to put below code on vba “ThisWorkbook” page, but do not know how to assign the macro.Must assign this macro to a button? C...
Hi Catalin, I did read the article, and tried with the example, that time i was not so understand what i am doing, i do not notice that i did not c...
Hi Catalin, Thanks for suggesting the append method for slicer part. GetPivotData is fix column right? but my rows and columns might change posi...
There are no relationship between the tables, but the users want to compare the results of parts table and the orders table for the 4 categories(Custo...
Yes.My original data source already is different data sets, that's why the both tables are totally not connected to each other. The real data on my...
I am sorry Catalin, my mistake to give you the wrong format of the columns source of the two tables which misconfused the concept already. Now i re...
The quarter and platform table which are not pivot table is just created for counting the correct percentage only, will delete after that. I need t...
Catalin, i am testing your sample, kindly refer to the customer tab,the percentage is still not accurate? I compare with the original source and t...
Oops..apologize forgot you do not have the credentials. Attached the sample file for the two tables source,powerquery merge table and including the...
all from second, matching from first is Right Outer? Full Outer is all rows from both I am sorry, still want to clarify that the merge concept is b...
Hi Catalin, Yes i have been looking for your link and testing it. Unfortunately i do not know how to apply on my case. Should i choose inner joi...
Hi Catalin, I am still confused for the merge query, forget to mention that the two table is not relate to each other and their id cant link togeth...