Alternative for Pick and match combination

[Venkey077]

HI Team,

I have an one field with all the metric field names like below...

Metric

Sales,
Quanity,
Orders,
Revenue,
Budget etc..

So used straight table to display values..
Dimension : Metrcic

Expressions like Y0,Y1....

In expressions put below formula for each year..

Y0 = Pick(Match(Metric, 'Sales','Revenue',Budget','Orders'),

//Sales

Sum({<Year={'Y0'}>} Sales),

//Revenue

Sum({<Year={'Y0'}>}Revenue) etc.....

Y1 = Pick(Match(Metric, 'Sales','Revenue',Budget','Orders'),

//Sales

Sum({<Year={'Y1'}>} Sales),

//Revenue

Sum({<Year={'Y1'}>}Revenue) etc.....

Y2= Pick(Match(Metric, 'Sales','Revenue',Budget','Orders'),

//Sales

Sum({<Year={'Y2'}>} Sales),

//Revenue

Sum({<Year={'Y2'}>}Revenue) etc.....

My Problem is that I should not use Pick and Match combination.

To display values like above is there anyway apart from Pick and Match combination.

Please help me with the solution or Without Pick and Match combination can't we implement?

Thanks in advance.

Regards,

Venkat.

[sandeep-singh]

Could you share a sample data for better understanding?

[Venkey077]

All these are numbers only...

Just problem is that to remove pick and match combination, Is there any alternative for Pick and Match combination

Thanks & regards,

Venkat

[sandeep-singh]

I asked a sample because the way you wrote expressions were incorrect. On your sample, Sales is the value of field Metrics but you are taking it as a field in your set analysis "Sum({<Year={'Y2'}>} Sales)". You can do aggregation on the field  but not on a value.

[Venkey077]

Yeah Noticed...Sorry for that

One field is there which is having values 

The field Name "Value " and it is having values like 10,20, 5%,6% etc...

Sum({<Year={'Y2'},Metric={'Sales'}>} Value)"

Please let me know if any additional information required.

Regards,

Venkat

[marcus_sommer]

What's the aim behind removing pick(match()) as approach to calculate different expressions in regard to the dimension-values respectively what's the issue with it?

[Venkey077]

As per best practices in my organization I should avoid Pick and match combination.

[marcus_sommer]

Not "best practice" is IMO quite questionable. Why - what's wrong with pick(match())?