Pl attach some workbook
1 of 1 people found this helpful
First you have to create inner join between order and returns table base don Order ID
Then Drag Order date on to the Column and select continuous Month
Drag Order date on to the filter and filter it based on Month/Year and Select January 2012
Now Put Order ID and select measure and countd
Now Drag Sale and Profit on the label
From show me palette select the 1st visualization i.e. Cross tab. Then, change the alignment of Measure Name from Row and Column. Similarly, change alignment of Month on Column to row.
Hope this helps!
Thank you so much, this was really helpful