Specific Field Value Issue

[Anonymous]

Hello All,

I have an issue where I want to get specific field value for my chart.

Example

I have a chart with Dimension as Year and Year I want  4 measures each with value of ECO Actual Duration where its Row number will be from the Output Format Sheet (its and example) i.e. 25, 50,75 ,100% Row Value

Please find the attached file for sample data

[robert_mika]

Like this?

CrossTable(COUNT, Data)

LOAD YEAR,

     COUNT,

     [25% Row Val],

     [50% Row Val],

     [75% Row Val],

     [100 % Row val]

FROM

(ooxml, embedded labels, table is [OUTPUT Format]);

[Anonymous]

Hi Robert ,

Thanks for Reply,

BUt  think I was unable to ellaborate my requirement.

Actually I need to create 4 expression

for 25% Row Val >> the value should be the value of ECO Actual Duration at 91 st row for 2013, 184th row for 2014 and 1675th value for 2015.

An so on..