Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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)))