Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)) > 0and
([Budget] >= 10000 or [Budget] = 0), [Budget] - [Totaal project])
thx in advance!!
Anita
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])
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