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!
-
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: neilgalyans
- Content: Threads
- Order by date
-
Metric Filters
First thanks to all that have helped me thus far - it has been invaluable New question.. I have a sales table.. I need to produce a report that shows sales by item, 1 total for ALL stores, 1 total for stores that are open for more than 1 year as of the sales date the report is run. I have...- neilgalyans
- Thread
- Replies: 2
- Forum: MicroStrategy, Inc. solutions
-
Advice please - variable calculations
Can someone give me some advice for a query I need to write.. Based on an date input from a Prompt I have built, I would like MSTR to calculate some different numbers: 1. We have a sales table that is identified with a Year,Period,Week(1-4) and Day of week (1-7) that has a column sls_amount...- neilgalyans
- Thread
- Replies: 1
- Forum: MicroStrategy, Inc. solutions
-
MSTR - Date manipulation
I hope someone can help me. Briefly, my company is new to MSTR, and I am setting up the database BI project. I have looked thru other posts and tried some things to solve my problem, but I am stuck: Our database is set up where each line (say a sales database table) has a Year column, Period...- neilgalyans
- Thread
- Replies: 6
- Forum: MicroStrategy, Inc. solutions
