is this pivot table possible?

[arctushar]

Hi
I have attached a file. in the sheet named "main" I have data. I make manually sheet "Door Count". Now I want a pivot table which will create sheet 'Door Count' style presentation from sheet 'main' data. is it possible.
if possible then plz give me suggestion. Or correct the file so that I can understand. Thank u

[Ishtiyaq]

Hi,

Please review the attached sheet for Pivot table. I've realigned the columns and removed the first column "count" because that count will be captured by pivot in row totals.

Warm regards
Ishtiyaq

Pivot table.xls

[arctushar]

Hi
This was Good. Thank u for ur cooperation. Actually I need as per my attached file. Thats mean First column should be count of Size. how it is possible? thank u

[Ishtiyaq]

Hi,

Its not possible using pivot alone, or may be I couldn't fiigure out a way to do so. However its possible when we use pivot and a macro. Please check the attached sheet I've added a macro to customize the pivot according to your requirements. You may have to work on the format a little bit but the data would be readily available. The short cut key to run macro is CTRL+W. Just refresh the pivot and press CTRL +W, data will appear in format you desire.

Hope this resolves your issue.

Warm regards
Ishtiyaq