0

robsmith Jan 15, 2015

You won't be able to do the subtraction in Groups. You'll have to do it in the Measure. So first clear your groups. If the measure syntax is:

avg(Q1)

... you'll have to change it to:

avg(filter(Q1,this_month==1)) - avg(filter(Q1,last_month==1))

It may help to view the documentation on filter syntax.

Leave a Reply


Please sign in to leave a comment.