Using Columns Headers as Dimensions

[Anonymous]

Hello community,

I am new to the community and I'm amazed with this software.
I've been trying to create a simple graph where the dimensions are the Column Headers.

I know that this isn't the best way to do this, but the DB is formatted like this...

For example:

Ship-To Party

Arrival Status

S/O Item(A)

TAT1_Line items

TAT2_Line items

TAT3_Line items

TAT5_Line items

I have under Ship-to Party a couple of Vendors and 3 different status under Arrival Status.

The S/O Item(A) is the sales category and under the TAT Line Items are the arrival quantities in 1, 2, 3, and 5 days.

I'd like to see the progression of the arrival quantities in the different days in a graph, where the dimensions would be the TAT lines (Column Headers) and the DATA would be the sum of quantities these columns.

What should I put in Dimensions and Expressions?

Thank you very much for the support!

[#2 · Accepted solution]

maybe you will like to use crosstable() in your load script.

reagrds

Darek

[sasikanth]

HI

Can you provide you DB table clearly ,,,,

[Anonymous]

Thank you very much!

I am new to the software and I'm doing some tutorials trying to learn new things!

Thank you!