why I have a different structure?
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
I have the sum of the values in the sheet not sure why
1 answers ( 0 marked as helpful)
Hi Hassan,
In this case, it is a bit confusing. Excel is showing you how it organized the data because there are multiple levels - it recognizes it is dealing with a date. First, we have Years and then Months in the column. Afterwards we have all values that fill in the columns. Consider that the date is of higher hierarchy and then we have the volues for each date. I realize that's confusing though.
Best,
Ned