Hi All!

I am working in Analysis Manager with cubes and dimensions.
The problem that I have is that I feel that one is limited to the the use of sql queries.

What i need to do: get the number of transactions for different stores -say 10 ( this I can do ) but then i need to get the total from all then give each store a percentage for their sales - this I cannot do.
e.g : 10 stores, total of 10000 transactions, now store "A" has 7000 transactions so he has 70% of sales so far.
How does one show the number of transactions and then the % as well?

Please help

Thanks

Gary