Creator : Filter Pivot Charts by a Function

Creator : Filter Pivot Charts by a Function

Currently pivot charts in creator will only show either all records or the logged in user records


I need to be able to add a filter calling a function I have created to show results based upon the organisation that the logged in user belows to.

  1. float Navigation.getOrganisation()
  2. {
  3.     varOrgID = customer[record_owner = zoho.loginuser].organisation;
  4.     return varOrgID;
  5. }
Can I call this function into a Creator pivot chart filter ?