5 Replies Latest reply: Nov 5, 2011 6:34 AM by Stefan Wühl RSS

    How to avoid supressed null values to be considerated in the total of the other dimension?

      Hi Have a pivot table that shows a total value of 700 when expanded and the value of 1000 when collapsed. How can I have the same value when collapsed of expanded?

       

      I Have three simple tables as show in the first image. Note that not all the regions include all the cities. Then I have a very simple pivot table (see second image). In the dimesion of Region i Check the option supress when value is null. Finally when I collapse this simple pivot table I get a diferent total. How Can I avoid this behaivor?

       

      Thanks in advance for your help.

      I'm attaching my qlikview file.

      http://www.smartware.com.mx/aTotales.jpg