Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
please check under "Data handling" if you have the option "Include zero values" checked.
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
could you post a sample app with mock data and the expected result ?