YT Functions Help
IMPORTANT:To make YT Sheet Functions work you have to go first to Extensions->Activate YTools Functions. Once you are using them in your spreadsheet this step is no longer necessary.
YT Date Functions
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.
YT Cross Table 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.