Problem in summarizing totales

[alf]

Hello all,

I am working with a dimensional model and want to have Country, Product and a query calculation field in a Crosstab. I see the result in HTML without any problem.
Problem is that Country has 60 members and Product has 36.260 members ( is the lowest level, product detail) and the calculation field must be done at the lowest level.
I am interested in summarizing this calculation at the lowest level by country. and here comes the problem. It crashes and no way to obtain. The best i obtain is the total by Country but mantaining the Product level and only in HTML no in Excel...
I have tried to filter out zeros but no way. Once you put a filter the output crash.

Please any suggestion¿?

Alfredo

[MFGF]

Wouldn't a tuple function do this simply? The tuple of each country member and your measure would summarise the measure for all products. Is this what you want?

MF.


Snet form my fumblefingers
iPhon 5 usig Tapatalk