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