Issue: the issue here is for sales $ its ok to sum the $ for last 3 periods for MAT.but for Customer count we want to have a distinct count of all the customers for the 3 periods not jus for individual periods and sum it up as this would be doubling becas a customer would have shopped in all 3 periods and we would be counting as 3 customers but in real life it was jus one customer. we are using distinct count of the customers and its ok when its run for one period its only issue when we use it in cosolidation for MAT(which is prd1+prd2+prd3).
 
If any one has any Idea or workaround to get this sorted that would be great.

Can you create 3 different reports containing these 3 attributes. If these reports doe not show any data upon execution, there is no sufficient data in your WH. Need not worry. You output would look fine once your move this dashboard into production environment.

I need some help with my dashboard. Am new to microstrategy and this is my first project. Can you please help me out.

 
I created the dashboard with same look and feel with metrics placed in the text boxes.
 
Now he wants three drop down selectors
 
Region     District  (Driven by Region)      Store  (Driven by District)
 
Should i directly place these selectors on document header and select Target as the grids in doument objects or Metrics in the dasboard. and select source as these resp. attributes.  ( I tried it but when i execute the document, drop down boxes are not populating the elements).
 
I tried using Panels , selected panels as Selector targets, but nuthing seems to work.
 
Am just stuck, i tried everything. Please suggest me.
 
I tried even grouping by these 3 attributes.   initially it selects all for three attributes and displayes about 16 documents for each region. As per the requirement it should display total for all regions( That is what i am thinking).
 
Please help me
 

Thanks,
Swetha