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

 

selecting last month of Quarter and last month of Year for diffferent measures

Started by rama83, 29 Apr 2009 07:29:56 AM

Previous topic - Next topic

rama83

Hi Masters,

I am having Croostab report with following measures: Amount Booked, Net payments, Credit Limit and outstanding Fee.
Suppose I want see the data in year wise Net payments, Credit Limit and outstanding Fee show the last month of year data(How much net payment in December) and Amount booked shows sum of all months.
Suppose I want see the data in Quarter wise Net payments, Credit Limit and outstanding Fee show the last month of particular quarter data(How much net payment in march(Q1)).

In single crosstab if I select year, quarter and month I want see the data above mentioned.

Its working fine for regular and measure Dimensions because in FM level we have to set Aggregate property to last for particular dimension.
Ex:Time Dimension for Net Payments to set Last  in Aggregate Property.

How the steps following in Relational Data Sources. Please any give the steps its very needful for me.

Regards,
Rama