2 Replies Latest reply: Aug 11, 2011 6:46 AM by Anita Fuchten RSS

    Pivot table sub-total for 1 column should not be shown ... help?

    Anita Fuchten

      I have a Pivot table which also shows sub-totals for the expression columns. The last column contains an expression which determines to show the content or not (e.g. budget below 10.000 is not shown) ... but with the count this is shown.

       

      See picture below (the green marked column sub-total):

      PROJECTS.PNG

       

      Anyone got suggestions how to solve this?

       

      The expression used in the mentioned column:

       

      if(
       count({<Year =, Month=, Quarter=,Week=,Day= >}total  <Projectnr>  if(Project.ProjectType = 'Project',Project.ProjectType)) > 0
      and 
      ([Budget] >= 10000 or [Budget] = 0)
      , [Budget] - [Totaal project])
      
       

      thx in advance!!


      Anita