-
1. Re: How to aggregate a calculated field
Tracy RodgersApr 23, 2012 11:48 AM (in response to harry.schroen)
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
harry.schroen Apr 24, 2012 2:29 AM (in response to Tracy Rodgers)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
-
HarBook91.twb.zip 18.9 KB
-
-
3. Re: How to aggregate a calculated field
Tracy RodgersApr 24, 2012 8:14 AM (in response to harry.schroen)
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
-
4. Re: How to aggregate a calculated field
harry.schroen Apr 24, 2012 11:24 PM (in response to Tracy Rodgers)Hello Tracy
see the attachment for the twbx file
-
HarBook91.twbx.zip 129.3 KB
-
-
5. Re: How to aggregate a calculated field
Tracy RodgersApr 25, 2012 9:33 AM (in response to harry.schroen)
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
harry.schroen Apr 27, 2012 2:17 AM (in response to Tracy Rodgers)Hello Tracy
Thank you
I've found that my calculation is not suited to 'drill' to a higher level.