I just basically added extra columns for each. I am not sure what will happen to my data if I were to divide it into a single column with totals. As stated in a previous post I still need the info in the original format with a column for Total Amount, 30, 60, 90, 110 Days, and then a lot of extra periods. Your way looks like a totally different look on how the data is imported.
Maybe I am not understanding your solution, but I really appreciate your help
Just to give you an idea of the actual amount of fields involved here is my actual script for the model I am working on. I have a number of graphs exploring the data by financial periods for ageing purposes. we also have a full table with detailed records if they want to do a search on individual records. This is where I see the problem as I cannot change the way the data is aligned, not sure if that is the right word. I am attaching the sample qvw source file so you can maybe show me exactly
SQL SELECT
Age.[AccountStatus]
,Age.AccountNumber
,Age.[MasterAccountNumber]
,Age.[BillingCycle]
,Age.[TownshipCode]
,Age.[Township]
,Age.[Ward]
,Age.[AccountTypeCode]
,Age.[AccountType]
,Age.[DebtorIndexCode]
,Age.[DebtorIndex]
,Age.[GroupDebtorTypeCode]
,Age.[GroupDebtorType]
,Age.[DebtorTypeCode]
,Age.[DebtorType]
,Age.[UnitNumber]
,[CurrentBalance]
,[ServiceGroup]
,[ServiceCode]
,[TotallingCategoryCode]
,[TotallingCategory]
,Age.[Advance]
,[Credits]
,[CurrentTotal]
,[PreviousTotal]
,[30DaysTotal]
,[60DaysTotal]
,[90DaysTotal]
,[120DaysTotal]
,[150DaysTotal]
,[180DaysTotal]
,[1800DaysPlusTotal]
,[210_360DaysTotal]
,[390_720DaysTotal]
,[750_1080DaysTotal]
,[1110_1440DaysTotal]
,[1470_1800DaysTotal]
,[TotalExcludingVAT]
,[TotalVAT]
,[AccountTotal]
,[SectionalTitleUnitNumber]
,[OwnerTenantCode]
,[OwnerTenant]
,[OwnerTypeCode]
,[OwnerType]
,[AttorneyCode]
,[Attorney]
,[AgentCode]
,[Agent]
,[CollectorCode]
,[Collector]
,[IndigentStatusCode]
,[IndigentStatus]
,[PermitPaymentExtension]
,[PaymentExtension]
,[PermitCutOff]
,[CutOffStatusCode]
,[CutOffStatus]
,[PermitInterest]
,[PermitLegalAction]
,[LegalActionStatusCode]
,[LegalActionStatus]
,[VIPAccount]
,[StaffAccount]
,[ApplicationDate]
,[FinalizationDate]
,[TerminationDate]
,[ClearanceApplicationDate]
,[ClearanceValidFrom]
,[ClearanceValidTo]
,[ClearanceCertificateNumber]
,[ClearanceCertificateDate]
,[Surname]
,[Initials]
,[DateOfBirth]
,[IDNumber]
,[CiproRegistrationNumber]
,[CompanyRegistrationNumber]
,[WorkTelephoneNumber]
,[HomeTelephoneNumber]
,[CellphoneNumber]
FROM V_R_DebtorAccountServiceAgeing Age
INNER JOIN V_R_DebtorAccountInfo Act on RTrim(Act.AccountNumber) = RTrim(Age.AccountNumber)
WHERE [AccountTotal] <> 0;
