YT Functions Help

These are:

YTQUARTERNAME

YTHALFNAME

YTFISCALYEARNAME

YTMONTHSTART

These are useful to qualify dates. You can summarize kpis based on these new dimensions. For companies which fiscal year does not coincide with the calendar year you can define in which month the fiscal year start and the function will qualify the date with the correct fiscal year. 

If the fiscal year coincides with the calendar year or this is not important, you can leave it blank and it will default to 1 (January).

You can use a fixed cell with a date or a range of cells with dates as input for the functions.

YTCROSSTABLE

YTCROSSTABLEPRO

These tables allows you to normalize a cross table into a "flattened" table. This allows you to:

• Analyze data using Pivot Tables

• Complement the information adding new fields to the new table, for instance using YT Date Functions to qualify a date for quarter, half or fiscal year. Or unifying the start month using YTMONTHSTARTDATE. You can do it also as groups in the Pivot Tables but sometimes is more practical to have these fields in the original database.

YTCROSSTABLE is simpler and applicable when the crosstable contains only one value accross a series of time. 

YTCROSSTABLE is more complex, thought for crosstables with multiple kpis mixed. 

Please see the screens below for more detail on how they work.