Forum Discussion
Sum 2 ranked columns together
Hi mikoal,
Did these filters use the same data table field?
If that is the case, you can't get different selections from slicers using the same data table field. I'd like to suggest you create an unconnected table and use it as the source of the second slicer.
After these steps, you can create a parameter table with all rank values and use it to create the matrix.
Then you can write a measure experienced with two variables to summarize and rank particular selection ranges, and extract the current rank as a condition to check and aggregate two variable table values.
Regards,
Xiaoxin Sheng
Hi XiaoXin
Yes they use the same data table.
But can't I use 2 different slicers to get 2 different date ranges? And 5 slicers for 5 ranges?
My main problem isn't getting the slicer to filter the data. my main problem is summing up the data of the columns into 1.
I'm not familiar with parameter table, do you have any examples of this and would this help with summing mulitple ranked time ranges?
I will also, search up some information regarding this. Thanks