-
1. Re: How to aggregate a calculated field
Tracy Rodgers
Apr 23, 2012 11:48 AM
Hi Harry,
Would you be able to post the workbook or a sample workbook (twbx files) so that I can better understand the issue? Thanks!
-Tracy
-
2. Re: How to aggregate a calculated field
Hello Tracy
You'll find my workbook in the attachment.
The table 'Dagdelen' contains transactions of the lowest level.
Teh table 'Groepkap' has capacity numers per group (groep) and per year, month
The calculated field 'Benutte capaciteit' calculates the occupation per groep, per month
If I take 'naam' (=Groep) from the shelf, the calculated field shows deviating results.
Thank you that you want to help me.
Regards
Har
-
3. Re: How to aggregate a calculated field
Tracy Rodgers
Apr 24, 2012 8:14 AM
Hi Harry,
I was unable to open the workbook. Would you be able to re-post it after taking an extract and saving it as a twbx file? Thanks!
-Tracy
-
-
5. Re: How to aggregate a calculated field
Tracy Rodgers
Apr 25, 2012 9:33 AM
1 of 1 people found this helpfulHi Harry,
The results are going to change when naam is removed from the view because the naam field has more members in it and thus the values are going to be broken down further. If you do not want naam to show in the view, right click on it on the rows shelf and uncheck Show Header.
Hope this helps!
-Tracy
-
6. Re: How to aggregate a calculated field
Hello Tracy
Thank you
I've found that my calculation is not suited to 'drill' to a higher level.