Forum Discussion
Dynamic titles with multiple slicers
Hi all, In my report, i have year, quarter, month and YTD/QTD/MTD slicers. I want to calculate dynamic titles according to my slicer selection and when no slicer selection is made, the title should ...
The problem is that, I have datas from august 2009 to june 2011. In that case, using max function is not helpful. By default, i.e; when no slicer is selected, it is showing 2011 and december.
You can do a max based on the calendar from your data, rather than max of the date table