Forum Discussion

Sbudd's avatar
Sbudd
Icon for Helper II rankHelper II
5 years ago
Solved

Sum on combined tables incorrect

Hi 

 

Im having a little difficulty with the below, I would like to combine 2 tables together that have 2 things in common Date and Default Channel Grouping.

Top table is a Summarized viz of my orders table (1), Bottom Table is summarized viz of my Sessions Table (2) and as you can see when i drop in Session to the top viz its the same values all the way down, when should be like the bottom table.

 

Any help would be hugely appreciated!

Thanks in advance 

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Sbudd ,

     

    you can create a measure that has to connect from one table to the other and set the relationship in this measure to bidirectional with the CROSSFILTER function.
    To test the result without a measure you could also quickly change the filter direction to bidirectional to check if that is the result you want.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Sbudd ,

     

    you can create a measure that has to connect from one table to the other and set the relationship in this measure to bidirectional with the CROSSFILTER function.
    To test the result without a measure you could also quickly change the filter direction to bidirectional to check if that is the result you want.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Sbudd's avatar
      Sbudd
      Icon for Helper II rankHelper II
      5 years ago

      Thanks Denis!! You're a star!