Two things Krunal
If you want Pivot table to do everything you have to bring both inward and outward transaction in one table but quantities in seperate column - Just like we do for banking transactions.
Else did you try the formula I gave you above - that shall summarize all your values at one place with as many conditions you want to apply.
Krunal if the solution resolves your issue, please mark the thread as closed and the post with probable solution. It help others to reach the solution faster.
Krunal if the solution resolves your issue, please mark the thread as closed and the post with probable solution. It help others to reach the solution faster.
#How to make this pivot table This type Need " Expenses" Summery Report in pivot table.
i was try but not showing this style.......
pleased help for this pivot table summery
(Query Purpose : if then 100 or more Party, Need party wise Different- Different Expenses use.... if then this Situation , How to making report for this type.....
Sir Kindly Understand and help me......again
*Pleased Help and Share Screen Shot ,
and Send Steps for how set data hader
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.