Have you ever struggled with editing your Ps document while on the go? Well, DocHub comes with an excellent solution for that! Access this online editor from any internet-connected device. It allows users to Join expense in Ps files quickly and anytime needed.
DocHub will surprise you with what it provides you with. It has robust functionality to make any changes you want to your forms. And its interface is so intuitive that the entire process from start to finish will take you only a few clicks.
When you finish modifying and sharing, you can save your updated Ps file on your device or to the cloud as it is or with an Audit Trail that includes all alterations applied. Also, you can save your paperwork in its initial version or turn it into a multi-use template - complete any document management task from anywhere with DocHub. Subscribe today!
hello friends in this video we will learn how to join two tables in a PS query lets go to reporting tools query query manager create a new query select any tables say ledger had record say in the first stage we want to select business unit account fiscal year and posted total amount we want to further filter for you business unit us 0 0 1 all the accounts and fiscal year say 2013 we want aggregate amount so we need to go to fields click on edit for posted total amount and select some click OK we can see that sum is written under aggregation for posted total amount try to run the process so these are the balances for 2013 for business community us 0 0 1 for various accounts now as the second part of the requirement we want to show account type also for all the accounts shown in the PS query for that we need to join a needle table with the existing query that is having account type as a field go to the now we know that GL account TBL is the table that we need to join when we click join