Multi Dimensional Bands

[rajeshvaswani77]

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.

Could you please help on this?

thanks,

Rajesh Vaswani

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[jagan]

Hi,

Rajesh,

Please find attached file for solution.

Regards,

Jagan.

[rajeshvaswani77]

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

[Gysbert_Wassenaar]

See attached qvw

[rajeshvaswani77]

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