Forum Discussion

AishwariyaV's avatar
AishwariyaV
Icon for Helper IV rankHelper IV
7 years ago

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 ...
Need Help
Show and Tell
Tips and Tricks
judspud's avatar
judspud
Icon for Solution Supplier rankSolution Supplier
7 years ago

Hi AishwariyaV 

 

*EDITED*

 

see responses below 

 

Thanks,

George

AishwariyaV's avatar
AishwariyaV
Icon for Helper IV rankHelper IV
7 years ago

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.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    AishwariyaV what you want to show you have to decide that and build the logic around it.

  • tjlee's avatar
    tjlee
    Frequent Visitor
    7 years ago

    You can do a max based on the calendar from your data, rather than max of the date table