How to apply the indexes awareness for 2 Dimension objects like 1 customer buying to 2 products(mobiles)..how to get the records ..?

Hi All,

Can you please any help me this below question ...?

1. How to apply the indexes awareness for 2 Dimension objects like 1 customer buying to 2 products(mobiles)..how to get the records ..?

2. I have 6 city's sales revenues So i want to 1-4 saperet 5-6 show only one value how to apply the pie chart ..?

3. I have customer , product and sales.So i want to date today and last values ...? both the dates (today and Yesterday)

All Please give any answers for both question ...

Thank You...to All Advance

Regards

Sridhar