Pivot Table Doubt

[manojkulkarni]

Hi Friends,

I have below data, which i am trying to project it in Pivot table but not able to display process name having no values in particular week.

How can we achieve this ?

Process	Date	Count
P1	01-05-2017	10
P2	01-05-2017	14
P3	02-05-2017	20
P4	03-05-2017	80
P5	08-05-2017	100
P1	08-05-2017	10
P2	08-05-2017	14
P3	08-05-2017	20

Expected Output in Pivot

Process	Wk1	Count
P1	1-5	10
P2	1-5	14
P3	1-5	20
P4	1-5	80
P5	1-5	0

[sunny_talwar]

Why is P5 = 0?

[manojkulkarni]

P5 doesn't have value in week1 but still need to show all the Process irrespective of data availibility

[neelamsaroha157]

One way of working it out is that add 1 as an additional expression and then hide that column

Pivot Column Width to Zero

[manojkulkarni]

Thanks for your reply. I tried this with Macro but when we export the data hidden column will appear.

Do we have any other way to do this ?