How to read pivot table data?

[znakeeye]

foo.xlsx
How do you read the pivot table data? I've tried all kinds of combinations, but none give me the right subset of fields/rows.

class Program
{
    static void Main(string[] args)
    {
        var wb = new XLWorkbook(@"foo.xlsx");
        var ws = wb.Worksheet("X");

        foreach (var pt in ws.PivotTables)
        {
            var r = pt.SourceRange;
            foreach (var row in r.Rows())
            {
                var v = string.Join(", ", row.Cells().Select(c => c.CachedValue));
                Console.WriteLine(v);
            }
        }
    }
}

Expected output:

Foo
a
b
c
d

Actual output:

Id, Foo, Bar
1, a, a1
2, b, a2
3, c, a3
4, d, a4

Ideally, I want to filter out any labels too.

Version of ClosedXML
0.95 beta2