Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivot Table with Null fields ( - ). I would like to return the sum for one year. The sum includes some null values.
I have tried so far with
Sum({<[Year]='2011'>}[Revenue]))
and this returns 0 or None, so that there is some mishandling of the nulls apparently.
Try Sum({<[Year]={'2011'}>}[Revenue])
This does not make it
Yes it does. It works perfectly here.