Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Thanks, Neelam!
It makes sense...
I'll offer it to the customer.