Information générale
Forum:
Microsoft SQL Server
Catégorie:
Services de reporting
Titre:
Analysis Manager Queries.
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement