5 Replies Latest reply: Dec 6, 2017 3:57 AM by omar bensalem RSS

    Show all value in pivot table

    aparna v

      Hi community,

       

      I have Day as column and month as row and

      Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'inactive'}>}ACCOUNT_CODE)

      as expression.

      Now i want to include days where FinalFlag is null(I want to show as blank) in pivot table.

      Any suggestions on this?