adding dynamic column in tablebox or straight table

[Anonymous]

productid  productpending days

1                           50

2                           20         

2                           45    

3                           40    

4                          100

5                          200

6                          110

7                           140

8                           500

9                            300

10                       450

this is my excel format

i want dynamic columns in tablebox or straight table

productid  productpending days     0       50       100    150     200

1                           50                           50              

2                           20                  20                        

2                           45                  45

3                           40                 40

4                          100                                    100

5                          200                                                          200

6                          110                                               110

7                          140                                               140

8                           500                                                          500

9                            300                                                        300

10                       450                                                           450

is it possible..its urgent

[swuehl]

sarathik87k,

I'm not sure if I understood correctly, what you meant with dynamic column, so here is an idea to start off.

I created a pivot table with dimensions productid and productpending days and and in addition

=ValueLoop(100,$(vMax),100)

as calculated dimension (and dragged this dimension later on to the top).

as expression I used something like

=if([productpending days] < ValueLoop(100,$(vMax),100) and [productpending days] >= rangesum(before(ValueLoop(100,$(vMax),100))), [productpending days])

Hope this helps,

Stefan