Custom Report

Report Inappropriate Content · ‎2014-03-04

Hi,

I have a requirement for Custom Report functionality in QV. I have created a custom report, but I want to limit my year variable to show only latest 2 years of data, however other sections of the dashboard needs all years. Can I restrict that in Custom Report.

Attached is tyhe sample QVW

Any help would be appreciated.

Simky

chiru_thota · ‎2014-03-04

you can do that

Variable1=max({1}Year)&chr(39)&','&chr(39)&max({1}Year-1)

Sum({<Year={'$(Variable1)'}>}Sales)

vikasmahajan · ‎2014-03-04

You need to build ad-Hoc reporting

PFA Sample

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Related Topics