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

[Anonymous]

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):

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

[lironbaram]

hei

attach is an example

but basicly change your expression to

if(rowno()>0 and
count({<Year =, Month=, Quarter=,Week=,Day= >}total  <Projectnr>  if(Project.ProjectType = 'Project',Project.ProjectType)) > 0

and
([Budget] >= 10000 or [Budget] = 0)

, [Budget] - [Totaal project])

[Anonymous]

Hi,

Didn't think of that ... so the normal rows are > 0 and the (sub) total rows have rownr 0?

Guesse for now I can solve this problem with your suggestion.

I thought I had to use something like aggr.

rgrds Anita