Straight Table Not showing all Results from Dimensions

[ivandrago]

Hi,

I have the attached Document, for some reason the results from the Straight Table chart "Credit Limit" is not showing all the Dimensions any reason as to why this is?

But if you filter a Fin Period it does show the Result for that Period.

Thanks

[florentina_doga · Accepted solution]

pls see attach

[sunny_talwar]

Its a grain mis-match problem

Pitfalls of the Aggr function

This should work

sum(aggr(sum(DISTINCT [CreditLimit]), [CustomerNo], [Fin Period]))