Hi all,

I think this should be relatively straight forward, but can’t find a simple solution…My data has 2 columns, a week of the year and a ‘score’

I need to create a spill result (so I can generate a dynamic chart), which separates the result of a filter into 3 columns:

Column1: Week 

Column2: Scores >50

Column 3: Scores <50

getting the three separate columns is not an issue, but it’s combing them into a spill result that I can’t fathom – using HSTACK with three FILTE functions means the scores/weeks do not align.

Any help much appreciated

​Hi all, I think this should be relatively straight forward, but can’t find a simple solution…My data has 2 columns, a week of the year and a ‘score’ I need to create a spill result (so I can generate a dynamic chart), which separates the result of a filter into 3 columns: Column1: Week Column2: Scores >50Column 3: Scores <50 getting the three separate columns is not an issue, but it’s combing them into a spill result that I can’t fathom – using HSTACK with three FILTE functions means the scores/weeks do not align. Any help much appreciated  Read More

​