The pivot view only supports a single field at present. We're planning on changing this in version 2.7. Until then, the Bar view supports unlimited paning, if you're ok with bars.

Alternatively, you can fake it by using a formula to concatenate text from multiple fields, e.g. "France EUR", "USA USD". If you do this, you might need to force the field to be a category field, rather than text.

Hi Steve,

Thanks for your response. Unfortunately this is a text report and the bar view (which is very useful in most of the cases) doesn't work. Also, the concatenation solution does not work because I need to group the data hierarchically and calculate sum and % at each level of grouping. As I mentioned earlier, the grouping function almost works, but not fully.

There are 2 columns, Month and Year, which need to pan across horizontally in the report, again, in a hierarchical grouped fashion. This is done automatically in an Excel pivot table. Is there any way you can suggest to implement this horizontal grouping?

Thanks again,
Indranil.

You may be able to get it to work using a sequence of views - you can add as many pivot views as you want, each with different configurations.

We'll take this case into consideration when we plan out future enhancements to the Pivot view.

In a future version we plan to add multi-tier axes (paning) in the Pivot view. This would allow you to set up the same date field in both Year and Month arrangements.