Page 1 of 1

NAV - Report options with Dimension, Company, Dates & Period

Posted: Mon Jun 20, 2011 1:03 pm
by PaulJet
Hi Everyone,

This Snippet is for an options sheet which includes the following:

-Start Date
-End Date
-Date Range (Combines the start date & end date to form a full date filter)
-Dimension 1 (Code & Name displayed)
-Company Name
-Period Type (allows you to select year, qtr, month, week)

Be sure when using the Snippet to place the upper left hard corner in cell A1 for it to work properly. This Snippet works best for financial reporting. Try combining it with the column generator Snippet and don't forget to use F3 as a short cut for the Excel named ranges look up.

I hope you enjoy and happy reporting....

Re: NAV - Report options with Dimension, Company, Dates & Period

Posted: Tue Dec 23, 2014 11:00 pm
by Andrio
ONLY FOR GB database as period localisations exist since V3.01