Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

help for put tables together

Hello!

I have this issue, im not sure if this possible to do this:

 

I have three tables in the layout of my report, and differents filter, some filter are for all the report and some only for a table, the table 1 have a search filter, table 2 is a top of the value, table 3 is show the last values. Is a way to put together in only one table and keep the filters for each one?

Or a way to put 3 tables in only one excel archive?

 

Thanks for the help

Mónica

Need Help
  • kohlivinayak's avatar
    kohlivinayak
    8 years ago

    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

     

     

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    Could you please share sample data of your table here and post expected result here?

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      This is the principal page of the report and we have differents filters..

       

      The filters Country, Date and Test affect the 3 tables in the layout, and the Keywords filters affect only the Search Terms. The others two tables (TOP Amount and Rounded Amount) they do other calculations that have nothing to do with the filter keyword. 

       

      I want to know if is possible put together the three tables but I don’t want the keyword filter affecting the other two (when I tried to put together with a merge, the top and the rounded are affected by the keyword filter. )

       

      Or another possibility is if there is a way to download a single excel file that includes the three tables of the layout. The user don’t what to have 3 excels.

       

      Thanks for the help

      Monica

      • kohlivinayak's avatar
        kohlivinayak
        Resolver I
        8 years ago

        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