Filtering multiple tables in one table in Excel

Question

Hi, i've multiple invoices put in one table and filtered like the included image.

i want to sperate the grand totals of each item automatically rather than filtering only one item each time i need to see its grand total. i'll demonstrate by pictures.

in order to. get the grand total of the item ""باغة" of all the invoices i've to filter the item and then get the highlighted cell. i've to do this for each item one at a time.

is there any way to do this automatically fo every item?

Answer 1

Hi, i've multiple invoices put in one table and filtered like the included image.

i want to sperate the grand totals of each item automatically rather than filtering only one item each time i need to see its grand total. i'll demonstrate by pictures.

in order to. get the grand total of the item ""باغة" of all the invoices i've to filter the item and then get the highlighted cell. i've to do this for each item one at a time.

Pivot tables generate summary information, like sums (and many other functions) based on specified criteria such as "item"

.

https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576 

.

If you provide us with a small example table (preferably with English text/column headings) we can demonstrate a pivottable with your data.

.

Upload Example - Share OneDrive File

There is no way to upload example files directly to this forum.

.

Trouble shooting problems using this text only forum can be like a visit to the dentist without anesthetics: a long, slow painful process of us trying to “extract” the clues needed to recognize the problem in a back and forth flow of questions and answers so that we hopefully can eventually come up with a / “the” solution.

. 

Often it is faster and easier for everyone if we have a “sample file” get "hands on", to look at, and to “play with”.

 .

This next link provides some tips on setting up a sample file and specific instructions for uploading and "sharing" it for us to access:

 .

https://answers.microsoft.com/en-us/windows/forum/windows_other-winapps/trouble-shooting-share-onedrive-file/a231a097-bcbf-4e34-ad6c-a33118baf471?tm=1523189328156

.

Includes a link to a macro to randomize text in Word. And another macro to randomize data in Excel

.

Note: make sure to upload to your Personal (consumer) OneDrive rather than your work OneDrive or SharePoint. Files in the Work cloud can be hard to share due to security restrictions placed by the work admins. Or use any other free storage service (anything other than business OneDrive or SharePoint).

15 Best Free Cloud Storage in 2021 – Up to 200 GB Free Storage
By Girdharee Saran - May 25, 2021
https://www.whizlabs.com/blog/best-free-cloud-storage/

.