Skip to Content
author's profile photo Former Member
Former Member

New column can't be added if the quantity is restricted by 0CALMONTH?

In our query design, first, we drag the characteristic 0CALMONTH (Calendar Year/Month) to the column, then drag the KF quantity to the column that we want to see the monthly quantity values for each Month_Year (eg Jan_1977, Feb_1977, ... Apr_2012, May_2012). It works.

Now we would like to add a new column to show the total of each month. But the frustration thing is that no matter how and where we put the new colunm with formula, find this new column is always be restricted by the 0CALMONTH for each month. Is there anyway to generate a new column which can not be restricted by the characteristic 0CALMONTH?

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 19, 2008 at 04:19 PM

    in such a case you cant use calmonth in columns. you should put that in rows.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.