Data Filtration 2

[mohan2391]

Hi,

I have 2 fields Region & Date and a few charts

Region           

--------

A

B

C

Date field is having data from JUNE-2016 to FEB-2017

My requirement is that,

1. When i select A in Region -- date field should show data from 10-JAN-2017

2. When i select B in Region -- date field should show data from 17-DEC-2016

3. When i select C in Region -- date field should show data from 6-NOV-2016

if nothing is selected should show all data.

How to achieve this ?

[buzzy996]

try tis way,

=Sum(If(Region ='A' and [Date]>='10/01/2017',[Sales Amount],

     If(Region ='B' and [Date]>='17/12/2016',[Sales Amount],

     If(Region ='C' and [Date]>='06/11/2016',[Sales Amount],

     [Sales Amount]))))

hth

[sasikanth]

One way is

Create variables , vRegionA,vRegionB, vRegionC

Write Exp in List Object:

If(Region='A',Date_Field>$(vRegionA) ,

IF(Region='B',Date_Field>$(vRegionB) ,

IF(Region='B',Date_Field>$(vRegionC) ,Date_Field)))