Hi,
I have a requirement to identify the max of the ProjectID along with the Dimension selected. There are many dimensions (Year, Region, etc).
This is the sample data:
| Program | ProjectID | Year |
| A | A.1 | 2007 |
| A | A.2 | 2008 |
| A | A.3 | 2009 |
| A | A.4 | 2010 |
| A | A.5 | 2007 |
| A | A.6 | 2008 |
| A | A.7 | 2009 |
| A | A.8 | 2010 |
| B | B.1 | 2007 |
| B | B.2 | 2008 |
| B | B.3 | 2009 |
| B | B.4 | 2010 |
| B | B.5 | 2007 |
| B | B.6 | 2008 |
| B | B.7 | 2009 |
| B | B.8 | 2010 |
| B | B.9 | 2007 |
| B | B.10 | 2008 |
| B | B.11 | 2009 |
So it has to work like this:
If no year is selected, the data shown would be:
| Program | ProjectID | Year |
| A | A.8 | 2010 |
| B | B.11 | 2009 |
If the year is filtered as 2007, the data should be shown as
| Program | ProjectID | Year |
| A | A.5 | 2007 |
| B | B.9 | 2007 |
So the Filter/ column to be added in the chart is Dynamic.
Can you please suggest how to accomplish this requirement.
Thanks,
SP
