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.
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!