Forum Discussion
Calculated Column return column Header Title if a condition is met - ie cell has a 1 in it.
Hi Anonymous,
As amitchandak said, do unpivot columns on your '# option' fields to convert them to attribute and value. Then you can create a matrix visual with name on 'row', value on 'column', attribute on value field to achieve your requirement.
Regards,
Xiaoxin Sheng
Anonymous can you paste the data and expected output as separate instead side by side, it is hard to understand what is going on there,
thanks... here's attempt 2 🙂
my data set as it currently looks, with 5 options and employee's selection of their Top 3.
Name #1 Option #2 Option #3 Option #4 Option #5 Option Employee 1 2 3 1 Employee 2 1 2 3 Employee 3 3 1 2 I'm keen to create some calculated columns that reflect the Header Title corresponding to the Employee's selection.
Calc Columns>> 1 2 3 Employee 1 #5 Option #1 Option #3 Option Employee 2 #2 Option #4 Option #5 Option Employee 3 #2 Option #3 Option #1 Option chasing a forumla that will return the Header Title corresponding to the number in the cell beneath it.
hope this makes more sense.
Tim