This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Initially used a join to combine the Point of Sale and Lookup Table before adding a filter to exclude dates recording transactions before 01/07/2013. Then used the summarize tool to sum the total transactions from the 1st of July. Cross tab was then used to group the transactions by TicketID and to display what each ticket entailed. Data cleansing used to turn the [Null] records into being displayed as 0's. Then used the formula tool to write a basic equation to calculate the number of deals before using summarize to total the number of potential deals. Final step was to use a formula to calculate the percentage of transactions that are potential deals.