Jump to content
  • 0
Sign in to follow this  

count calculation in pivot table


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.


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


regards Peter .



Share this post

Link to post
Share on other sites

1 answer to this question

Recommended Posts

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
Sign in to follow this