5 Replies Latest reply: Jul 12, 2013 11:02 AM by Rajesh Vaswani

# Multi Dimensional Bands

Hi All,

I have the below set of data

BU,UCR,Amount

BU1,U1,10

BU1,U2,100

BU2,U3,50

BU3,U4,200

would like to display display the data in the table with bands as below (segregated at the level of BU and UCR, Note that BU1 has two UCR's falling in to two different bands.)

 BU <15 15 - 50 50 - 100 100 - 200 BU1 1 0 1 0 BU2 0 1 0 0 BU3 0 0 0 1

Current result is shown as BU1 showing count of 2 under Band 100 - 200. Which we do not want.

Attached is the attachment that has the scenario.

thanks,

Rajesh Vaswani

• ###### Re: Multi Dimensional Bands

See attached qvw.

• ###### Re: Multi Dimensional Bands

Hi Gysbert,

Thanks for your Help. In continuation to this, below table is the result that we are expecting.

 BU <15 15 - 50 50 - 100 100 - 200 >200 BU1 0 0 1 1 1

The data has

BU,UCR, TR,CDate,Amount

BU1,U1,TR1,01/01/2013,10

BU1,U1,TR7,01/02/2013,50

BU1,U2,TR2,01/02/2013,100

BU1,U2,TR8,01/03/2013,10

BU1,U6,TR3,01/08/2013,250

Sum of U1 for BU1 will be 60

Sum of U2 for BU1 will be 110

Sum of U6 for BU1 will be 250

The qvw file for this example is attached.

thanks,

Rajesh Vaswani

• ###### Re: Multi Dimensional Bands

See attached qvw

• ###### Re: Multi Dimensional Bands

Thank You, Gysbert. The solution works perfectly.

One last question I have is on how I could filter based on these Bands:

 <15 15 - 50 50 - 100 100 - 200 >200

Is there a way I can setup a Multi Box or a List Box with these bands. On selection of a band, I need to see just the data for the selected band(s) on the table.

thanks,

Rajesh Vaswani

• ###### Re: Multi Dimensional Bands

Hi,

Rajesh,

Please find attached file for solution.

Regards,

Jagan.