Help

[panipat1990]

Hi,

    Is It Possible To Have a Dynamic Title Of a Particular Sheet as per the maximum sale Which Is Changing EveryDay..My Title Display City Name Which Should Keep On Changing EveryDay and must Display Only The NameOf City Having Maximum Sales...Can anybody Please Share a Formula or Send A qvw With Example...

[#2]

Store the Top1 value of City and total sales into a parameter, then in the sheet properties under title, call the parameter.

[parthakk · Accepted solution]

Hi

In sheet properties under title write the following code

Concat(if(Aggr(Rank(sum(sales))<=1,city_name),city_name),',' & chr(13))

Thanks,

Partha Kulkarni

[parthakk]

Sorry instead of sum(sales) write max(sales)