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

    Multi Dimensional Bands

    Rajesh Vaswani

      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