I want sundays to be shown in pivot table

[#1]

hi all,

I have a pivot table with the dimensions week, weekday, date and on top i got the store like this

                                                       store1          store2

week1      Mo     date1

                  Tu     date2

                  We     date3

                  Thu     date4

                  Fri        date5

                  Sa       date6

                  So       date7

sunday usually has no value (expression: sum(profit)) I still want it to be shown how is it possible??? and I have some stores with null values but they shouldn't be shown and this is where my problem starts

regards,

MT

[Anonymous]

hi

         one simple option is u can uncheck the suppress null and missing values in presentation tab of the respective chart......

regards,

vaibhav

[#3]

if i do that all the sundays will disapear because the usually have no profit!! but i have also stores they have never profit and the ones that have never profit i dont want to see

regards

[Anonymous]

ok

can u attach d app?

[Or]

You should be able to get this done by checking "Show all values" for the "Weekday" dimension, I think.