topic Re: Null dimension values in pivot table in App Development

Null dimension values in pivot table

AJM — Thu, 12 Sep 2019 14:29:12 GMT

Hi,

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?

BR,

AJM

Re: Null dimension values in pivot table

StarinieriG — Thu, 12 Sep 2019 15:00:28 GMT

Hi,

a possible workaround is about mapping null values inside the script

Re: Null dimension values in pivot table

AJM — Fri, 13 Sep 2019 06:25:24 GMT

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?

Re: Null dimension values in pivot table

StarinieriG — Fri, 13 Sep 2019 07:18:35 GMT

I think that you couldn't have a table in which some rows has 3 dimension, and others 1 or 2 at the same time.

Maybe try to use condition of each column, for example:

1) Len(field)<>0: dimensions disappear and, if you select rows that have value, column will be show

2) You could create a button that allow to show/hide column

Re: Null dimension values in pivot table

AJM — Fri, 13 Sep 2019 07:25:43 GMT

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.