Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dinamic Dimension

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

1 Reply
johnw
Champion III
Champion III

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