Skip to Content
0
Former Member
Jan 10, 2008 at 06:07 AM

District wise Dealer Count query

56 Views

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.