4 Replies Latest reply on Oct 22, 2016 7:12 AM by Łukasz Majewski

    Grand Totals not showing for calculated field measure

    paolo.raia

      Hi.

       

      I have created two calculated fields: Total Cases and Average Cases, with calculations as follows:-

      WINDOW_SUM(COUNT([CaseNo]))

      WINDOW_AVG(COUNT([CaseNo]))

       

      What I cannot seem to do is have them calculate at GRAND TOTAL level and they also appear left-aligned:-

       

      If I take out a dimension from the ROW shelf, I get the below which I want to appear in the GRAND TOTAL in the above screenshot (although Average Cases should be the average of the column not sum):-

       

      Thanks for your help in advance,

      Paolo.