• 0
Login to follow this  
peterhanse

count calculation in pivot table

Question

Good morning , 

I have a Pivot Table Report .

I'm looking for a solution to replace the "13". For the count of all records with kostentest_cat = 1 (that are 13 records).

can someone help.

 

CASE
WHEN [@field:kostentest_cat] = 1
THEN [@field:kostentest_hoeveelheid]-([@voorraad_ruw]/13)
ELSE [@field:kostentest_hoeveelheid]
END

Naamloos.png

regards Peter .

 

 

Share this post


Link to post
Share on other sites

0 answers to this question

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Login to follow this