Hey Guys,
I am trying to compare one month to another. The trick is I need MonthYear set as a dimension. I found the attached example which is very close I just need to move the Jul numbers to the Aug row. Here is what I need it to look like:
| Salesperson | MonthYear | Aug-2005
(CM) | Jul-2005
(PM) |
| | $163,613 | $143,666 |
| Brolin, Helen | Aug-2005 | $16,946 | $14,456 |
| Callins, Joan | Aug-2005 | $3,239 | $15,631 |
| Carsson, Rob | Aug-2005 | $20,146 | $26,097 |
| Hendrix, Ingrid | Aug-2005 | $5,629 | $14,395 |
| Lindwall, Tom | Aug-2005 | $26,072 | $30,515 |
| Presley, Erik | Aug-2005 | $12,097 | $8,577 |
| Roll, Frank | Aug-2005 | $35,276 | $14,729 |
| Shine, Leif | Aug-2005 | $19,912 | $10,705 |
| Skoglund, Lennart | Aug-2005 | $24,296 | $8,561 |
Any ideas would be great.
