Jump to content

Peter Gar

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Peter Gar

  • Rank
  1. Your solution works great! Unfortunately when I try to reproduce your solution in my existing database i get the following. (Your correct report is on the left, my incorrect report is on the right) Any clue what I'm doing wrong? Peter
  2. I have a boatload of daily transactions that i want to create a report with. Comparing revenue from one year to the next. How do I create a report that shows 2005 sales and 2006 side by side? It would look something like this: DATE - 2005 - 2006 -------------------------------- Jan 1 - $1234 - $3456 Jan 2 - $3456 - $2341 Jan 3 - $567 - $97 Etc. --------------------------------- Jan Totals - $5287 - $5894 I've enclosed some sample data. Thanks in advance for your help! Peter 2005_2006_transactions.tx
  3. Søren Enclosed is a file with 38000 records. Run the report and you'll see an error i cant figure out. Can you tell me why the summaries for the higher number of transactions have so many customers? It doesnt make sense to me. The data doesnt back it up. Thanks again for all your help. I OWE YOU! Transactions5.zip
  4. i didnt even know FM could do that... way cool!
  5. BINGO! The latest fix is exactly what i'm looking for! THANK YOU! Peter
  6. SD, The goal is to know the total number of people who have 1 transaction, 2 transactions etc. the report would look like this: Number of Transactions - Number of individual users 1 - 30,000 2 - 5,000 3 - 2,500 4 - 400 5 - 90 7 - 4 11 - 1 Does that make sense?
  7. Soren, I think you are close. The goal is to know how many individuals bought once, twice, etc. See my original post. THANKS AGAIN! eter
  8. YOU ROCK! Thanks for the example. I attached a sample data file with 1000+ rows of data. Its much simpler than yours. Simply a column of transaction numbers and a column of corresponding customer numbers. My goal is to know how many customers had 1 transaction, 2 transactions, 3 transactions etc. THANKS AGAIN! data.txt
  9. What you suggest is way over my head. Any chance you can build me an example in the data i provided? Thanks in advance (either way)! Peter :P
  10. I have a database of transactions that contains a 38,000 unique transaction numbers and customer number field. There are dramatically more transactions than customers. I want to generate a report that looks something like this: 1 transactions - 30,000 2 transactions - 5,000 3 transactions - 2,500 4 transactions - 400 5 transactions - 90 7 transactions - 4 11 transactions - 1 Total Transactions - 38,000 The report simply tells me how many repeat customers i have. How do i create a report that looks like this? I've included the data.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.