I want to have a cross tabular view of my data. I tried using Pivot table as well, but the result was not satisfactory. Please see pic above. In my report in need to show -(say by row 1).
in Sep'13 total 176 users get registered, out of which only 7 place orders in Sep'13, only 14 place orders in Oct'13, only 18 place orders in Nov'13, and so on.
Similarly for Oct'13, total number of new users getting registered is 308. Out of these 308 users only 11 is placing orders in Oct'13, 29 are placing orders in Nov'13, 30 are placing orders in Dec'13 and so on.
I have also search online sources, but could not get anything satisfactory. Can anyone help me on this.