Cross Tab reports for Cash flow
Trying to create a cross tab cash flow report. As you would expect, WBS will be rows and columns will be months. I use Datapoint Date element as columns. But the result is a big disappointment as you may see below. Since Datapoint date is string type or for another reason, months and years are not ordered correctly. Any ideas.
Name | 2013 02 | 2013 08 | 2012 12 | 2013 03 | 2013 09 | 2013 10 | 2013 11 | 2013 01 | 2013 05 | 2013 06 | 2013 07 | 2012 11 | 2013 04 | 2013 12 |
Basic Materials & Methods | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Basic Metal Materials & Methods | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Basic Thermal & Moisture Protection Materials & Methods | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Basic Wood & Plastics Materials-Materials | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Bid Development | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Bidding | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Bonds & Certificates | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Casework | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Cast Decks & Underlayment | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Cast-in-Place Concrete | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Ceilings | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Central Cooling Equipment | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Central Heating Equipment | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |
Central Hvac Equipment | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 |