Hi Guys,
In simple words, I have a report that has two rows with date in colums. The first row are Offers made to customers in that period, the second row is the number of customers that purchased the offer.
I want to include a third row to show ratio of Purchase/Offer in percent. Show all three rows.
See matrix and sample twbx attached. Thanks in advance.
TypeJan-19Feb-19Mar-19Apr-19Offer9,16610,69319,9784,384Purchase3,8944,2976,3231,369% Purchased42.5%40.2%31.6%31.2%
3 answers
Dan,
Make a calculated field: Percent:
{FIXED [zCF_Period]:(SUM(IF [Type]='Purchase' THEN ([Counts]) END)/SUM(IF [Type]='Offer' THEN ([Counts]) END))}
and move it to "dimension" , then drag it to columns, set number format to percent.
Hope it helps.
Michael Ye
