1 Reply Latest reply: Apr 12, 2016 10:20 PM by Sunny Talwar RSS

    getting problem with Only Function

    Subba Reddy

      Hi Folks,

       

      I have a data, for that i want to show Previous Quarter Data.

       

      Measure Expr:-

       

      If(GetSelectedCount(Quarter)=0,

      Count({<QuarterNo={$(=Max(QuarterNo-1))}>}Fdbk_Typ),

      Count(Fdbk_Typ))

       

      Header Expr:-

       

      'Total Survey Response' &' ' &

      If(GetSelectedCount(Quarter)=0,

      Only({<QuarterNo={$(=Max(QuarterNo-1))}>} Quarter),

      GetFieldSelections(Quarter))

       

      Its showing only data available Quarter. As below attached "Samsung " don't have data for Previous Quarter. So simply i want to show as 0.

       

      Can any one help wit this..

      Sub2u444