Dynamic Label (Pivot)

[#1]

Hi All,

I have a table below loaded:

Version	Mth	Cust	Value	Actuals
1	Jan	a	232	543
1	Feb	a	232	434
2	Mar	a	54	32
2	Apr	a	6	78
2	May	a	7	23

What I want to show is:

1. The label for the 'Value' of the pivot table be change to Value <latest version of the month>

2. So above, I selected Feb and Mar, should output: Value (1) | Value (2)

Is this possible?

Thanks all

[c_gilbert]

In the caption, I would probably use the following expression:

=GetFieldSelections(Mth)