You'll need to pivot your data:
In the data source, control or shift click on visits and revenue and right click and select pivot
The field will be automatically named as pivot field names and pivot field values, you can rename these if you wish.
Create a calculated field called : Coupon Code Value
IF [Coupon Code]<> 'None'
then [Pivot Field Values]
^ This calculated field essentially filters out the data to just rows which have a coupon code.
And another calculated field called: % to Total
SUM([Coupon Code Value])/SUM([Pivot Field Values])
To create the view, drag pivot field names to rows, measure names to columns and bring the measure values into text.
Reorder and reformat as necessary (e.g. turn percentages into percentages format):
Please see the workbook attached.
Crosstab_v10.2.twbx 7.4 MB