Skip to Content
0
Former Member
Mar 19, 2008 at 04:17 PM

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

12 Views

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!