Forum Discussion
Measure into column
Hi Anonymous ,
If you don't want to see the extra data, you could create a new measure to set rules which returns 1 or 0. Then show data whose measure =1 or 0 in the filter pane.
This is a calculation for Sell Through column that returns expected results.
Now, I'm using the same formula for the "Exlude" column which I would like to use as a filter, however, It doesn't work the way the sell through column does.
you can see that for rows = 1 , it says "Yes". It should say "No" according to formula.
If I don't summarize the "Sell Through" column the "Exclude column" calculates it right and that's what it's doing even when summed up. But this is not what I need. It must be summed up TaskID
I also tried to add a measure which works fine
but when I try to build upon that and do a column that uses that correct measure, it doesn't return the correct results:
I'd really want to know how to overcome this. If it's the best, please message me and I could send you the sample file I work with directly to your email if that's fine.