I am trying to do a statement for the top 10 slot machines by number FOR location (property), but I cant seem to figure out where to put the ( ). The tip would help if my statement was like their example, but its not.
topcount([RD Detail].[RD Detail].[Slot Machine or Table Seat],10,[Chips/Coins In Amount]for [Location])
the tip says....
aggregate_function(expression FOR expression {,expression})
Any ideas?
syntax is:
sum( [Quantity] for [Product Line], [Product Type])
I think you misunderstood my question. I am trying to use the topcount function, to get the top 10, not sum. Thanks though. I was able to make it work.
The sum was just an example... It should work for your function too. You asked help for the "FOR" syntax...