Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filtering using the same table as base

Hello To all   I'm trying to show in a report info that should be filter by two values that are in the same table, if I do it as it is I get zero results (which is correct).   How can I do this? ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

It seems it's better to make auxiliary tables .

 

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello v-cherch-msft


    Just did. I breaked the table B in two

     

    Table B1

    id wid value type
    1   1     2        1

    3   2     5        1

    4   3     3        1

    6   4     8        1

     

    Table B2

    id wid value type

    2   1     4        2

    5   3     9        2

     

    by using FILTER with type.

     

    But now if I link them to table A will I not get the same result? Or am I beeing a newbie.

     

    Thanks

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous

       

      I reviewed your question and I think i cannot fully understand it. Why not use wid column in TableB as slicer to get it as below picture? Using type columns as slicers seems more complicated.

       

      Regards,

      Cherie

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello v-cherch-msft

         

        I cannot use wid because in fact what I need to display is the value of Table A filter by both types.

         

        I need to get the wid that as both type 1 and type 2 and use that to get the value of Table A.

         

        In SQL seems more easy... :)

         

        Regards