How can do vary my straight table with 2 slicers.

[suzel404]

Hi all,

I have a straight table with 2 slicers Start and End. And I want to vary my table with 2 slicers.

How can achieve that ?

Thank for your help.

[#2]

Hi.

Use Sum({<Start={">=$(vBeginAt)"},End={"<=$(vEndAt)"}>}Amount) in expression.

[#3 · Accepted solution]

I basically said to show all values around my two slicers. Where the End is after my BeginAt slicer AND the begin is before my EndAt slicer. So, anything that'll have some reference inside my two slicers.So, if my slicers sit from 48000 to 50000 I want to be able to show all records that would have at some overlap in my selection.

Simply paste this formula into your Expression replacing sum(Amount)

=Sum(

    {<

    End={">=$(vBeginAt)"},

    Start={"<=$(vEndAt)"}

    >}

          Amount)

[Anonymous]

PFA ,

Hope this helps

[suzel404]

Thank you. My problematic is a little different.

I need to select the Range StartEnd. When I select the StartEnd Range I can see the previous and forward Range.

And I need to play with the 2 slicers  Start and End to see orders  and distance between my interval Start and End.

When I mixed the display Previous/Forward StartEnd Range and the variation of slicer, nothing happen.