Problem : I'm trying to use a pivottable to automaticly create certain tables for me.
1.png
2.png
In 1 i created a table with data. In 2 i created a pivottable with data.
Now my question is : Is it possible to show in the outcome of the pivottable ( in the white area ) for example in "hoogte dagmaat" a total number of lets say 240 but in "U waarde" something like <20 w/m2k.
I'm trying to make a pivottable that automaticly uses my data, doesnt do anything with it but just organizes it correctly. Normally you can always do "show as value or show as text" when you rightclick the cell, but in the pivottable it doesnt work.
I'm open to use macros/functions/ etc whatever it takes.
Many thanks for your time!
Bookmarks