Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MyJash21
  • Order by date
  1. MyJash21

    MDX - Avg Per Store

    Hi, The MDX query given below returns result for all years. i just want it to return for a specific year (let's say 2005), how can i achieve this? please advise WITH MEMBER [Measures].[% Sold] As '([Fiscal Year].CurrentMember.PrevMember...
  2. MyJash21

    MDX - Avg Per Store

    Hi Justin, Thanks for your prompt response. Let me try your suggestions.
  3. MyJash21

    MDX - Avg Per Store

    Hi, I MDX query return the result as follows; Week Stock Sold 1 500 100 2 350 50 3 300 50 But I wanted to have the result as; Week Stock Sold % Sold (Calculated field) 1 500 100 Null 2 350 50 50/500 = 10% 3 300 50 50/300 = 16.6 % Note: “% sold” field of each week should be calculated as...

Part and Inventory Search

Back
Top