one great advantage of Qlikview is that you don't need to predefine and load any cubes or(and) cross tables. Just load the data and build the cross tables using new object --> charts --> pivot table --> dimensions are month and color, expression is sum(count).
Thank you for your response. I think I will find that tecnique useful in the future
However the example I posted above is just to learn the technique of buliding from cross tables because my final and real LOAD will be a long piece of SQL which has many sub headings which I cannot reproduce through a pivot table and I need to restructure my data first in the edit script
My ultimate aim is to produce a scorecard type table with many subheadings.....Hence the need to cross table
If you are able to help me with how I can get to a cross table situation using the example I posted above, any help would be greatly appreciated