line chart tow dimensions and tow measures

[#1]

Hi,

there is any option to show in line chart tow dimensions and tow measures?

I need to show the quantity for each year per company and the sum of all the companies per year.

in line chart i can put only one measure and in combo chart I can Use only one dimension.

thanks!

[swuehl]

You could create a dimension in the script for your chart that shows all companies plus a TOTAL value:

LinkTable:

LOAD Company, Company as ChartDim

RESIDENT YourTable;

CONCATENATE (LinkTable)

LOAD Company, 'TOTAL' as ChartDim

RESIDENT YourTable;

Now you can use the ChartDim dimension with your Quantity expression to show all companies in combination with the TOTAL line.

[#3]

Thank you so much for your answer, swuehl, it worked very well.