hello all
i am new to BEx. i am facing one problem in counting districtwise & division wise number of dealers.
i want to get the result in the following format:
District | No. of Dealer - Lighting* | No. of Dealer - Fans* |
- they are divisions.
so the query goes like this:
in the selection first the user will enter the Region(E, W, N, S). then in that region whatever districts comes, i want to get the division wise (ie, lighting division, fan div. etc.) distribution of the dealers in that.
how do i write the query to get this data? pls help.