Data Comparison 2019 vs 2020 - How to create a Statistical Chart

[marmar89]

Good Afternoon,

I would like to create a statistical analysis of the attached figures, separated by year and then bank and non bank. i.e.

Bank 2019 vs 2020 All Countries (January to April 19/20)
Mobile Bank 2019 vs 2020 All Countries(January to April 19/20)
Non Bank 2019 vs 2020 All Countries (January to April 19/20)
UK Non-bank 2019 vs 2020 (January to April 19/20)

Could someone please help me figure out how to do this as I am not sure how to choose multiple pivot tables to create comprehensible charts

Much appreciated!

Regards,

Marlon

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[marmar89]

Hi Pepe,

My apologies! I managed to find a workaround by myself How can I resolve the thread please?

Thanks,

[Pepe Le Mokko]

Please add the link as requested.
And perhaps share your solution with the board?

[marmar89]

Hi Phillip,

Link: https://www.mrexcel.com/board/thread.../#post-5470238

Workaround: create filters similar to the attached, and then go on Insert -> Pivot Table and from the right hand side under "Pivot Table Fields" you select the fields you would like to add/exclude to the report. One can also make use of the drag fields option within the PivotTable fields to determine where each field should be displayed.Attachment 678398