Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks it worked.