Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table and a date filter(Single selection filter)
when no date is selected from the filter the data in the table is of max date
when we select the filter the data changes accordingly but as the data changes I want to show the comparison via colors
if (count({$}empid) > count({$1}empid),green(),red() )
In case of landing page ie when no date is selected the color should be black , but on first selection the comparison should be made with default date (max date)
so you want to compare the selected date with the max date to generate the colors ?
yes exactly but only on the first selection and afterwards the comparison should be done on current and previous selection of dates