Unpivot unpredictable results

Hellos,
Back with another round of Unpivot question. 

i attached my input file (sales.report.csv) , output file(output.csv) and transformation file. 

I am getting unpivoted grouping on half of data , I have played around but cannot get the output to change.

  

UNPIVOTING

 

You want to create 6 rows for every input row, that means that you have to create 6 groups, but you have created only two

The WIKI has an example

www.etl-tools.com/wiki/advanced-etl-proc...orming-data/unpivot/

This one works




 

Peter.Jonson wrote:

You want to create 6 rows for every input row, that means that you have to create 6 groups, but you have created only two
 

I think THIS as a thumb rule helps , Each breakdown of input row into X require X groups.

Or did I mess up the thumb rule?