I'm trying to reproduce an Excel sheet in QlikView. On the Excel sheet, there is one part which is crosstable like, with two dimensions (a datatype and a month) and data - but then there are some columns which have only one dimension (the datatype, but not the month dimension), so they are present only once, not once per month.
You can add the other columns as dimensions if they are fields. If they are calculations you need to add them as calculated dimensions. But all dimension columns will be on the left side of the pivot table.
