Hi,
Pls help how to display the value in cube with out updating original table
Table
---------
p1 date qty
100 20100101 1000
100 20100201 0
100 20100301 0
200 20100401 500
200 20100501 0
In cube i need to display as follows (i.e, qty should be displayed for all same p1)
p1 date qty
100 20100101 1000
100 20100201 1000
100 20100301 1000
subTotal 1000
200 20100401 500
200 20100501 500
subtotal 500
Thanks in advance
Regards...Gugan