Forum Discussion
ljx0648
2 years agoHelper III
Sum column based on Multiple Parameter
Hi guys, I have a datatabel like this Custmer count = the total number of customer with the assets on the right. I have also created a field paramter Parameter = {
("Mutual Fu...
Anonymous
2 years agoNot applicable
Hi ljx0648
I did a lot of testing for the question you asked.
It turns out that you can't compare their same values by selecting multiple parameters.
Because your parameter is a column name, when you select multiple parameters, you cannot merge the results of the two columns into one column.
This is the main reason why you will get blanks.
Perhaps you can do this by breaking up a table into multiple tables based on columns. It's the most effective way I can think of it.
Hope you can find a more suitable way to solve the problem.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ljx0648
2 years agoHelper III
Thank you for your advise Nono. I will give it a shot