5 Replies Latest reply: Jan 19, 2018 8:42 AM by Andrea Gigliotti RSS

    pivot table

    fabio Mazzarelli

      Hi Community,

      could you help me?

       

      I 'll try to explain my needs.

       

      I created an app in which i'm using a pivot table

       

      APP: EXAMPLE

      filter1: no selection

      filter2: no selection

                                         measure   

                                     col1           col2    col3

      dimension row1          aaa          bbb     cccc

      dimension row2          aaa          bbb     ccc

      dimension row3          aaa          bbb     ccc

       

      all dimension are displayed correctly

       

      BUT IF I USE A FILTER

      filter1: customerxxyyzz

      filter2: no selection

       

      row related to "no data"  are not rapresented

      so that my table is

                                         measure   

                                     col1           col2    col3

      dimension row1          aaa          bbb     cccc

      dimension row3          aaa          bbb     ccc

       

      Exist a way to represent the dimension even in the absence of data?


      Fabio  Mazzarelli

        • Re: pivot table
          Rama Sai

          Hi Fabio,

           

          i hope you while you created the Pivot table you may be Un-check the option

          Include Null Values (Select your chart-->in the properties select your dimension-->Drop down options will come--> below the Label you can find a Check box Include Null Values, do it for all Dimensions and Measures and then you will get your result )


          so please check that for each dimension and Expression then you will get the result.

           

          if you didn't get result please post with your sample application with sample data.

            • Re: pivot table
              fabio Mazzarelli

              Hi

              i checked all check box including Null values.

               

              But values are not null; we are in the presence of data not present because the filter (customer) does not find any data for that dimension.


              I would like to be able to create a pivot table with all dimensions as well as images

                                             measure   

                                             col1           col2    col3

              dimension row1          aaa          bbb     cccc

              dimension row2

              dimension row3          aaa          bbb     ccc


               

               

            • Re: pivot table
              Andrea Gigliotti

              please check under "Data handling" if you have the option "Include zero values" checked.

                • Re: pivot table
                  fabio Mazzarelli

                  Hi

                  i checked all check box including zero values.

                   

                  But values are not zero; we are in the presence of data not present because the filter (customer) does not find any data for that dimension.


                  I would like to be able to create a pivot table with all dimensions as well as images

                                                 measure   

                                                 col1           col2    col3

                  dimension row1          aaa          bbb     cccc

                  dimension row2

                  dimension row3          aaa          bbb     cc