Horizontal display in a pivot table

[dafnis14]

Hi,

The request is to display a pivot table with horizontal dimension of sales.

No period selection is needed.

The challenge is that beside each month, the difference % from previous year has to be displayed for each month.

The idea of defining 24 expressions is puzzling...

Any suggestion about the way to approach it?

Thanks!

[neelamsaroha157]

You can use a pivot table with Month field on the top and use only two expression 1 for the current month and other for the previous. the only difference the your view and this one would be that you will have Month being divided by 2 columns as Current and previous.

[dafnis14]

Thanks, Neelam!

It makes sense...

I'll offer it to the customer.