I have a cross tab layout that uses filtered portals to show record counts of Demos and Orders that fall between two dates.
The portals are based on a Self Join that matches on a Product ID (stored in a Global field in the parent) and the values in two date fields, Demo Date and Order Date. The counts shown below are correct but I also want to show a conversion rate for each column.
For example, the conversion rate for May-17 would be 33.87% (21/62)
I've named all of the data objects on the layout and confirmed in the Data Viewer that the objects can be used in calculations but I don't know how to store the results in variables to show the results for each column.
is there a way to do this or is there a better way to do this that doesn't involve naming objects?