how take a Value of a dynamic variable that load different field.

[pascos88]

Hello, I load different excel sheets with the same format in a variable Value.

for Each Value in '', ''

IST:

First 12

LOAD AB as Data,

     AC as Production,

    AH as EBITDA,

       '$(Value)' as NomeCompany

  FROM

[1510_Performance Report_As Database.xls]

(ooxml, no labels, header is 103 lines, table is $(Value));

Data	Production	EBITDA	NomeCompany
jan	25550000	14222
dec	4575211	9851

I have a table like this.

Now I need to have the  names of Company to do a chart bar.

if I put like dimension =$[NomeCompany] and like expression Production, dosn't work.

How I can have this Value?

I attach my project and the chart that I should to do is the chart in the right side where it is possible to select Month YTM and Forecast.

For each Company when I click on a month I should have the information about the month selected (This is calculated from an formula, but even if I can show only the production fer exemple for each Name it will be done).

I am able for any questions.

Regard

Pasquale

[sinanozdemir]

With bar charts, I think you need to put an actual expression/function such as count, sum, or min & max. !