for examlple, I want to sum the sales data group by sale month and the city of sale. from jan 1012 to Dec 1012, but there are no sales data for some month .
if the user want to all 12 month in 1012, how to do it .
You can get it using Level based measure with level Month and City.
Create a metric sum(sales) and set content tab for Levels Month and City, that would result query as
sum of sales group by Month, City
If this is not what you are expecting pls give us more details.
If helps pls mark
Edited by: Srini VEERAVALLI on Jan 18, 2013 10:51 AM
Edited by: Srini VEERAVALLI on Jan 29, 2013 9:42 AM