Names

[arethaking]

Hi All,

How to show report name as below:

If 2016 is selected then 2016 Current Year Sales

If 2015 is selected then 2015 Sales

if 2016 & JAN is selected then Jan-16 Sales

Thanks in advance.

[Chanty4u]

HI

YTQ, QTD, MTD and WTD

[tresesco]

May be like in attached sample.

[tamilarasu · Accepted solution]

Hi Aretha,

Have a look at the attachment.

[Anonymous]

Hi Aretha,

Try this code on the title:

=If(GetSelectedCount(Month)=0 and GetSelectedCount(Year) = 0,'Sales',

    IF(GetSelectedCount(Month)=0,

        If(GetSelectedCount(Year) = 1,

            If(Year = Max({1} Year), 'Current Year Sales',Year &' Sales'),

            Concat(DISTINCT Year,' - ',Year)&' Sales'),

        If(GetSelectedCount(Month) = 1,   

            Month&'-'&Right(Year,2) &' Sales',   

            Concat(DISTINCT  Month&'-'&Right(Year,2),', ',Year*100+Month) &' Sales')

    )

)

Regards!

[tamilarasu]

Aretha,

  I have almost covered all scenarios. Have a loo at the attachment.