FieldValue in variables

suzel404 — Tue, 03 Jun 2014 20:02:51 GMT

Hi all,

I have a complex situation to realize.

I have a straight table with range / Start / End / StartEnd / Measure

When I select the range StartEnd I can see Previous StartEnd and Forward StartEnd.

For Example I select StartEnd 10000 - 20000

I get Previous StartEnd 8500-10000

and Forward StartEnd : 20000-30000.

When I do vary my slicer with vStart and vEnd, I would like in straight table :

STARTEND START END

8500-10000 8500 vStart

10000-20000 vStart vEnd

20000-30000 vEnd 30000

So, If I put Distance field, I can see distance and profitability vary between the range StartEnd above and below.

Thank for your help.

Re: FieldValue in variables

suzel404 — Tue, 03 Jun 2014 20:22:33 GMT

Updated data.

suzel404 — Wed, 04 Jun 2014 10:20:09 GMT

I use avg and Aggr function.