Forum Discussion
echo a cell to a new column
That's what I thought. Did you try to replace your formula by the one I gave you?
For example, for the first record I see, Instead of having 1246, 1577, 931, you should have 1, 0, 0
For the 4rd record, if you change the formula for the three columns, you should have 0, 0, 1.
So, the aggregation function should work.
Séebastien
Thank you both for your prompt replies.
Here is what i have at present.
As you can see in order to get a visualisation of each team i have to filter it as an average - otherwise it will total them.
I have tried looking around - but i suspect my question is so simple that it is not mentioned anywhere!
I have experimented with measures but it seems that this is more related to cross reffrencing different tables.
That's what I thought. Did you try to replace your formula by the one I gave you?
For example, for the first record I see, Instead of having 1246, 1577, 931, you should have 1, 0, 0
For the 4rd record, if you change the formula for the three columns, you should have 0, 0, 1.
So, the aggregation function should work.
Séebastien
Brill - Thank you Sebastien - i did try your suggestion - but it came up with syntax errors - so i will go through it more carefully and let you know shortly!
Tim