Hi All,
I have a Date field in the format 'DD-MM-YYYY hh:mm:ss'. I have used this DATE field in three filters as YEAR, MONTH AND DATE.
For YEAR I have applied the expression as year(Date field)
For MONTH I have applied the expression as MONTH(AGGR(Date field,Date field)) in order to remove the grey color values.
for DATE I have applied expression as =DATE(FLOOR(Date field),'DD-MMM-YYYY')
I want is to hide the greyed out values totally based on selection in previous filter box.
example: Current scenerio
The Filter Value selected by User is depicted in BOLD
YEAR MONTH DATE
2019 JAN 1 JAN 2019 (coming as white color)
2018 FEB 2 JAN 2019 and so on till 31 jan 2019(coming as light grey color)
1 feb 2019 (coming as dark grey color)
2feb 2019 ... and so on till 28 feb 2019(coming as dark grey color)
If I select JAN as month for year 2019 I should get only JAN dates but the date filter is also displaying feb dates as well in dark grey color. Also when I select JAN as month, feb month is getting disappear, it should come in light grey color.
My main concern is to remove the dark grey color values
what changes I should apply in the filter expression in order to hide the dark grey color values based on selection in previous filter pane.
Kindly help.
Thanks
