Please help[DMR]... Need help with aggregation on dimension not used in report

[Adam_Clone]

I have a simple line graph requirement.

X-Axis -> Time (Year, Quarter, Month)

Measure -> Revenue of that Product, that had the highest of all Product revenues in that time category.

Tried "Maximum([Revenue] within set [Dimensional Layer].[Product].[Product].[Product])", but it simply shows the total for the time category and not the max.

[Adam_Clone]

Figured it out ppl.... Its the same calculation:

Maximum([Revenue] within set [Dimensional Layer].[Product].[Product].[Product])

Just make sure to add the level ([Dimensional Layer].[Product].[Product].[Product]) as a property of the column in the crosstab.
Thats all!