CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Red face advanced cross-tab needed

    Hi Everyone,

    I have an issue that I would like to see if you can help me with.

    I am trying to create a crosstab that will show amount1, amount 2, amount 3 grouped by month - Jan-Dec (columns) and rows are numbered 1-31 (example:1 representing day 1 in jan). Looks something like this:
    Jan Feb
    amount 1 amount2 amount3 amount 1 amount2 amount3

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10

    How in the world do you achieve something like this without having to create formulas for each day of each month for 3 amounts?????

    Thanks for your help everyone.

  2. #2
    Join Date
    Feb 2012
    Posts
    1

    Re: advanced cross-tab needed

    try the crosstab
    place table.date into row
    create a formula for amounts something like
    if some condition then "emount1" else
    if different condition then "emount2" else
    "emount3"
    place it into columns
    then place table.data_your_summarizing into summarized fields.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured