Connecting Slicer to two different Tables

[Farid Tanwar]

Hello Ninjas,

I am enclosing the sheet containing both Receivables and Payables data on a single worksheet, as required by management.

Both tables have one common field, which is Month. However, I am currently unable to connect a single slicer to control both tables simultaneously.

The requirement is that when a specific month (for example, March) is selected in the slicer, the visual should display both the Receivables and Payables data for that same month.

Kindly advise on how this can be achieved.

Thank you in advance for your support.

 

[vletm]

Farid Tanwar​

There could be some challenges to 'Filter' those with 'Slicer' ...
... but could You use something like this?

 

[Farid Tanwar]

Thank you!

can you suggest more simple solution

 

[vletm]

Hmm...
Now, there are four formulas and one data validation.
# Data validation - You can delete it and manually write Month.
# Headers - You could copy and paste those from original tables.
# Two Filter-formulas ... if ... simple means ... less then - maybe someone else could offer something
Too many times - ... simple ... means opposite.

 

[p45cal]

can you suggest more simple solution

You won't get much simpler than that.