HEADING IN CHARTS

[#1]

Dear All

I have charts & Pivote table which are working fine , but now i have to add a heading Sales Order  Date From xxxx  To xxxx

I have only one field order date.

Please let me know any trick to show this even Order date is not in selection .

means by using possibly selected view ,  min and max

Regards

Pramod Kumar

[lironbaram]

your header should be

='Sales Order  Date From ' & date(min(order date)) &  ' To ' & date(max(order date))

[vijay_iitkgp]

Hi Pramod,

Your question is not very clear. You can use  two variable VMinDate =Min(SalesOrderDate) and vMaxDate=Max(SalesOrderDate) and use them in heading. Hope this will work for you

Vijay

[#4]

Vijay , In pivote tabels , we have row which consist of name fields.

can we add one super heading "Sales order details From $vMindate To $vMaxdate)

Regards

Pramod Kumar

[vijay_iitkgp]

Can you please provide sample . 

[#6]

Dear Vijay

This is the Sample file . Please get that

Regards

Pramod Kumar

[vijay_iitkgp]

No Attachement.. . I m using QV Personal edition so I cdnot be able to open your qv file. Can you please provide image of report you want.

[SunilChauhan]

try this

='Sales order details From   '& date($(vDateMin) )&' To  '& date($(vDateMax))

hope this helps