Add Measure calculating Avreages of Avreages

[dzuser]

Hi,

I have a table:
                         TransactionId,ProdcutId,SubCategoryId,CategoryId,Amount

I want to get One Measure that calculate:
1. [Avg(Amount) Of ProcuctId :   If i Select ProductId
2. [Avg of Avg(Amount) Of ProcuctId] : If i Select SubCategoryId
3. [Avg of Avg of Avg(Amount) Of ProcuctId] If i Select CategoryId.

Avg(Amount) By TransactionId By grouping is not working

can you help me pls ?

Thanks a lot

[Lynn]

Hi,

I have a table:
                         TransactionId,ProdcutId,SubCategoryId,CategoryId,Amount

I want to get One Measure that calculate:
1. [Avg(Amount) Of ProcuctId :   If i Select ProductId
2. [Avg of Avg(Amount) Of ProcuctId] : If i Select SubCategoryId
3. [Avg of Avg of Avg(Amount) Of ProcuctId] If i Select CategoryId.

Avg(Amount) By TransactionId By grouping is not working

can you help me pls ?

Thanks a lot

If you set the aggregation method of amount to be average then the figure should be averaged based on whatever else is included in the layout. I don't think you'd need separate query items for this as the single amount measure with average as the aggregation method should be sufficient. What do you mean by average of averages?

The "is not working" explanation is a real pet peeve and specifically addressed as a no-no in the forum etiquette. Some specific examples that show what you get vs what you expect might help you better illustrate your issue.