CrossTable Help

[tahirkhalil]

Hi,

I have data as :

Invoice Nr	Invoice Line	Cost Category	Actual Value	Estimated Value
INV01	1	Finance Cost	7	5
INV01	1	Ink	10	8
INV01	1	Paper	200	200
INV01	1	Starch	9	7
INV01	1	Total Cost	226	220
INV01	1	Total Material	219	215
INV01	2	Finance Cost	3	2
INV01	2	Ink	5	6
INV01	2	Paper	110	100
INV01	2	Starch	4	4
INV01	2	Total Cost	212	113
INV01	2	Total Material	119	110

I like to use CrossTable while loading this XLS as:

Invoice Nr	Invoice Line	Paper Est Value	Ink Est Value	Starch Est Value	Total Material Est Value	Finance Cost Est Value	Paper Act Value	Ink Act Value	Starch Act Value	Total Material Act Value	Total Cost Act Value	Finance Cost Act Value	Total Cost Est Value
INV01	1	200	8	7	215	5	200	10	9	219	226	7	220
INV01	2	100	6	4	110	2	110	5	4	119	212	3	113

Can someone suggest how to use CrossTable?

Regards,

TK

[sunny_talwar]

I think what you might need is a Generic load:

The Generic Load

But I suggest keeping the data as is and create a pivot table on the front end to view the data as your second table.

[vinieme12]

I personally feel you can make best use of your existing data structure without making changes, this way your expressions will be simpler

[tahirkhalil]

Thank you Sunny & Vineeth,

In fact for some calculations, I need to modify the structure, secondly, I need to reduce the data rows in QVD.

Regards,

Tahir