If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

calculating total taking one value from each month

Started by NDP, 28 Oct 2008 10:21:38 AM

Previous topic - Next topic

NDP

I know this is simple but I am having little tuff time

I have to calculating yearly value by taking just one value form each month
I have start date and end date for promp page

I have one TAX value is always there for each month.
So i need to show yearly total vlaue of TAX (ex 12*50=600)

thank you for you guidence




blom0344

Quote from: NDP on 28 Oct 2008 10:21:38 AM
I know this is simple but I am having little tuff time

I have to calculating yearly value by taking just one value form each month


Set grain of query to monthly and apply a min/max for the measure. However, do you need control over the value that is returned for each month.
Hard to advise without having a notion of the data you are working with..

Suraj

There is not enough detail to give a specific suggestion.
For generic idea, blom gave that above.


bonniehsueh

Quote from: blom0344 on 29 Oct 2008 04:48:19 AM
Set grain of query to monthly

How do you set a grain of a query to monthly?

Is it putting a [month] data item in the query and displaying month with the other data items on the List?