Re: Return a dimension from expression(set analysis)
It's lumping all other customer into one row. So if I created a table using the dimension you helped me with this i what I would get:
Cust Number CY Sales PY Sales
3 2000 0
4 300000 0
- 1001000 120000
I know I can uncheck the Show Null Values on the dimension, but I was hoping I could accomplish that in the expression. I'm trying use this to create a KPI, but because it's returning all of the other values my total is way off. I hope I explained that properly. Thanks again for your help!
The measure also sums up the totals for the null values. Essentially all I want is a ytd total in a KPI for any customer that did not buy anything last year. The table works for this, but I just like the way the KPI looks.