I am trying to create a report that looks like:
The first row is in the column named MPM_Description.
The second row is the Release date of those movies and the third row is the box office collection. The column to the left is the accounts name. The table is filled with the POS(point of sale) value for each movie titles.
The input data is like this:
I tried using proc report but could not succeed. I even saw some papers dicussing about the columns in Proc report but I am not sure which column to in order to get the desired output.
I am really looking for the answer.
Thank you,
Shankar