Use running total as column field for Cross-tab
Posted on 2009-07-01
I want to create a cross-tab where each column has the same record number of each group.
Meaning that the first record in every group will be in the same column, and so the second and the thrid records of every group will be in the same column respectively.
So what i mean is a running total that resets upon change of group.
i have created a running total (both with crystal and a manual running total) and tried it but its not available for the cross-tab.
Maybe i'm using the wrong approach, but all other fields i have to use as column are number fields or date fields. these wont work. the numbers dont have any particular order they are just a value for that record. as for The date, it will force to put them in groups of date (monthly, daily, every second) but wont help to get records in the same column.
How can i work around this?