Hi Guys,

I want S. No. in Piovt Table like
If I collapse Date then S. No. Main should work. Althought, I'm doing this manually by unchecking blank cell in "S. Sr.No.Pivot.xlsxMain" and If I expand then Sub S. No. should automatically expand. Is it possible in Excel Pivot Table ?

I"m attaching the exel file for further clarification.

Thanks.



Manual S. No.
S. Main Sub S.# DATE CORES_NO.
1 1 26-Mar-12
2 27-Mar-12
3 28-Mar-12
4 29-Mar-12
2 5 1-Apr-12
6 5-Apr-12
7
8
9
3 10
11
12
4 13
14
15
5 16