in
Forums
Blogs
Files
Devexpress.Com
Client Center
Support Center
DevExpress Channel

Adding Empty/Missing Months

Last post 9/7/2008 7:46 AM by Ivan Milosavljevic. 0 replies.
Page 1 of 1 (1 items)
Sort Posts:
Previous Next
  • 9/7/2008 7:46 AM

    Adding Empty/Missing Months

    I have created pivot table like this:

                 |  January | February |     March |        April |

     

    Item1     |       1000 |       1000 |       1000 |       1000 |

    Item2     |       2000 |       2000 |       2000 |       2000 |

     

    I have to add missing months into column fields (May, June, July and so on ...) how to achive this ?

    Final look should be like

     

                 |  January | February |     March |        April |         May |        June |         July |   August | September |   October | November | December |

    Item1     |       1000 |       1000 |       1000 |       1000 |             0 |             0 |             0 |            0 |                 0 |             0 |               0 |                0 |

    Item2     |       2000 |       2000 |       2000 |       2000 |             0 |             0 |             0 |            0 |                 0 |             0 |               0 |                 0 |

     

    Thanks!

    Ivan M.

Page 1 of 1 (1 items)
Copyright © 1998-2008 Developer Express Inc.
ALL RIGHTS RESERVED