16 Replies Latest reply: Sep 7, 2016 2:07 PM by Sunny Talwar RSS

    Row total Custamization

    neelam sehrawat

      Hi,

       

      I have a Pivot table where I have to customize the Row level totals and the data is for rolling 12 months.

      The expression I am using is:

      Capture2.PNG

      if(IsNull(RowNo()) , 'n= ' & (Count(DISTINCT {<[Key Date Type] = {'DISCHARGE DATE'},Date ={">=$(vRolling12MinDate)<=$(vAsOfDate)"}, Year = , Month = , Quarter =>}SURVEY_ID)),

      (Count({<[Key Date Type] = {'DISCHARGE DATE'},Date ={">=$(vRolling12MinDate)<=$(vAsOfDate)"}, Year = , Month = , Quarter =, ScoredStatus = {'1'}, CAHPS_Box_Type = {'TopBox'}>}RESPONSE)/

      Count({<[Key Date Type] = {'DISCHARGE DATE'},Date ={">=$(vRolling12MinDate)<=$(vAsOfDate)"}, Year = , Month = , Quarter =, ScoredStatus = {'1'}, CAHPS_Box_Type = {'*'}>}RESPONSE)

      )*100

      )

       

      The result is as per requirement BUT the only issue is its showing all other Month-Year(All data scrambled in image) that falls out of the condition with no data.

      Capture3.PNG

       

      I can't figure out what I am doing wrong.

       

      Would appreciate any help.

       

      Thanks