Dynamic subtotal column heading

Posted on 2006-05-30
Last Modified: 2006-11-18
I have a crosstab that is first grouped by Year and then by quarter. It contains two years worth of data and will continue to grow. I want the title of the first subtotal column to say "overall" and this year's subtotal to say "YTD". I have tried writing a formula and sticking it into the text field, but it does not change depending on the year.

if ({year})="2005" then "Overall"
else "YTD"

only returns 2005 for both the 2005 grouping and the 2006 grouping.

Am I trying something that is not possible?
Question by:jennifer_borman
    LVL 7

    Expert Comment

    This formula should be used as the column in the Crosstab, not the year.

    if ({year})="2005" then "Overall"
    else "YTD"

    Author Comment

    The reason that the year is being used is so that it shows

    2005                                  2006
    Q1  Q2  Q3  Q4    Overall     Q1   Q2         YTD

    That is what I am trying to accomplish. Otherwise if I just do by quarter the data would not seperate out by year.
    LVL 7

    Accepted Solution

    Ok, I misunderstood.  I don't think it is least not with 8.5.

    LVL 100

    Expert Comment



    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now