Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the caption, I would probably use the following expression:
=GetFieldSelections(Mth)