I have three dimensions in pivot table (all as rows). My dimensions display hierarchy levels that partially have null values (the 1. level does not have nulls, but the 2. and 3. level have, I have loaded the data as inline load and defined there to be null values if empty/no level). When I display the three levels as indent rows it also shows the null values.
My problem is that when I untick the include null values -box from the second or third dimensions, the dimensions also disappear. So not only the null values disappear, but all the dimension values. Is there a way to go around this or am I doing something wrong?
Thank You for your answer! If I map null values, I guess I would still have the problem that I have to show something that I do not want to. In my pivot table I would like to show the second and third dimensions if there is a value and if not, I do not want to show anything (so if I would use null mapping, there would be something to show, but I would have to hide it somehow?). Is there a way with null mapping to hide the originally null dimension values in some way after I have done the mapping?
Thank You again! I will try those out and see how I can make them work. I was thinking about changing these hiearchies that I have, but for some level 1's and level 2's there is no real life equivalents for level 2's and level 3's, so I am hoping that your solutions could work.