Dinamic Dimension

[#1]

Hello,

I have 3 tables:

Branches
Vendors
Loans

And I need to build a single object that tells me the amount of loans by year / month period.

Example:
I should have a list with 2 options selection (Branches / Vendors). In this case I Choose branches. Then my view should display.

Branch - 2010/09 - 2010/10 - 2010/11
Mendoza - 199 - 205 - 350
San Luis - 201 - 35 -980

In this case I choose Vendors. Then my view should display.

Seller - 2010/09 - 2010/10 - 2010/11
Perez - 19 - 25 - 35
Godoy - 21 - 3 - 98

How do I make this work?

Greetings

[johnw]

Maybe a cyclic group with the Branch and Vendor fields in it? Not sure I understood what you were asking.