help for put tables together

Hi Anonymous

ok I created a table with user, amount and state (instead of keyword)

for top and bottom i created a rank column, you already have top and bottom, based on amount and filtered top 3 and bottom 3

Then i created 3 tables with summarize function - one for top , one for bottom and one for search and added two more column

First column have top 3 in text for records in top 3 table, for bottom table i have bottom 3 for search table i repeated state column here (keyword in your case)

and one more column to sort things

Now instead of keyword in slicer we put this new column (Now you will have option to choose top 3 or bottom 3 or your normal search keyword)

I know its not exact solution to your problem, but you can get help with this. I will need more details to help you further.

find this Attachment : Merging Table.pbix

Thanks

Vinayak Kohli