I have a table that has Sales data. The columns are GrossSalesAmount and Date. I want to use the ChicletSlicer to categorize the data into 3 date filters: Year-To-Date (YTD), Month-To-Date (MTD), and Today (TOD). what I did so far is the following: I created a calculated column that gives each row a value: Y (for Year), M (for Month), and T (for Today). If the value of Date is for today, it will give the value T. Else, if the value of the date is the current month, it will give the value M. Else, if the value of the date is the current year, it will give the value Y. Else, it will give the row the value N (for None). The table will look something like this (for example's sake, assume today is February 13th 2019): GrossSalesAmount | Date | Filter ------------------------------------------------------ 12,333 | 13 Feb 2019 | T ------------------------------------------------------ 444,444 | 10 Feb 2019 | M ------------------------------------------------------ 444,444 | 4 Feb 2019 | M ------------------------------------------------------ 111,111 | 24 Jan 2019 | Y ------------------------------------------------------ 111,111 | 15 Jan 2019 | Y Now, I created another table called Filter which has One colmn, Category, with 3 values: Y, M, and T. I created a one-to-many Single relationship between Category (from Filter table) and Filter (from Sales table). The ChicletSlicer uses the column Category to list the 3 filters Y, M, and T. What I want is the following: when the user clicks on T, it will show him the Sales data of the row that has the value T. If the user clicks on M, it will show him the Sales data of the rows labeled BOTH T and M. If the user clicks on Y, it will show him the Sales data of the rows labeled T AND M AND Y. How do I do this?
