Pivot table

[#1]

i am facing a challenge in pivot tables as when i am trying to load the data from DB into pivot table with few filter conditions some of the rows are getting excluded so the corresponding dates are also getting excluded due to this there is date jump happening in date dimension but i want all the dates in date dimension, please help me in achieving this. below screenshot current status of the pivot table. thanks in advance.

[settu_periasamy]

what do you mean by filtering condition? Can you share your expression?

[#3]

hi Avinash,

It actually worked thanks for your valuable time in this course.

and also I have unchecked suppress Null values in Dimension tab and I got the output that I desired.

[avinashelite]

cool good to hear that i was able to help you

if you have got the answer please mark the correct and helpful answers , so that it will be helpful for others who are having the similar question