I am completely stumped on how to approach this scenario. I have a dimension (ex: Products) with values but there is a null field in the dimension that is messing everything up. My problem is that I can easily suppress the null field but that throws off my totals. The client doesn't want to keep the null field either.
How would you approach this scenario? I'm so lost and just looking to the community.