Dimension Aggregation Issue

[#1]

I'm having an issue with a straight table.

I created "Date-Posted buckets" (Posted Month) and for 5/1/2013 it's not aggregating under the $'s Col. column. It seems to be related to more than 1 account qualifying for the bucket. All other buckets have a 1-to-1 relationship to the $'s Col. and # accounts that qualify.  I'm not sure why this isn't aggregating.

Here, you'll such the relationship between account # and bucket. Any insights on why this is occuring? It should aggregate to $6,372.25. Thanks,

[MK_QSL]

can you post your sample file or apps?

[#3]

Hi Brett, it be great to have a bit more info. If you are unable to post the app, as manish suggested, could you tell us more? eg What is the function in the $'s column?

I wonder, if it is because that is the day with more than 1 account attached to it, it is some aggregation issue in the function.

Erica