I have joined two datasets. Then I have blended an additional data set which contains some static variables.These statics variables are the categories of our clients.
The challenge that I am facing is that the table calculations that I am performing only seem to work properly when I use the category called clients. Which is the one I used to blend the data sets. If I try to do the same calculations using employee type instead, it is not working properly. However if I edit the data connection and use employee type instead, it works.
I should have said that the categories are the exact same ones for employees and clients.