Pivot chart - advanced view

[srans]

Hi,

Looking at simplifying a pivot to show a view as in the attached format (Desired_format.gif):

From the excel data sheet, the default pivot view that I get is also attached (Pivot_default_view.gif)

The pivot view looks complex as a report view. Any help/suggestions to simply the view would be very much appreciated.

Thanks in advance.

[dilipandey]

Hi srans,

welcome to the forum.

Try moving shop column to left side.. also it would be helpful if you can upload a sample workbook instead of an image. thanks.


Regards,
DILIPandey
<click on below * if this helps>