I am facing one problem to create the pivot table . I am having two dimension and one expression
when i was creating the general count it is giving correctly and when i use the aggr() in the expression ,it is giving the value in different place (i.e when you write the aggr() the value of jan2013 in xais and jan2013 in y-axis it should be one value,but it not giving any value)
i am using the function aggr(count(clientid) startmonthyear)
The pivot table should be like the sam.png file having the data.
See attached. If you don't need the totals consider turning them off - if you need them to load you can use the Dimensionality() function in an if statement..
